APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SALESREPS

Line 235: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,

231: -- ===========================================================================
232: PROCEDURE reset_payrun_id
233: (
234: p_payrun_id IN cn_payruns.payrun_id%TYPE,
235: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
236: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,
237: p_payment_group_code IN cn_pmt_plans.payment_group_code%TYPE
238: ) IS
239: BEGIN

Line 377: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,

373: -- Calls :
374: -- ===========================================================================
375: PROCEDURE distribute_pmt_plan_amount
376: (
377: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
378: p_pmt_amount_adj_rec IN NUMBER,
379: p_pmt_amount_adj_nrec IN NUMBER,
380: p_payment_group_code IN cn_srp_pmt_plans_v.payment_group_code%TYPE,
381: p_period_id IN cn_payruns.pay_period_id%TYPE,

Line 1538: -- Salesrep should not be on hold -cn_salesreps.hold_payment

1534: -- API body
1535: -- The following validations are performed by this API
1536: -- Check for the following mandatory parameters payrun_id, salesrep_id,
1537: -- Pay run should be unpaid
1538: -- Salesrep should not be on hold -cn_salesreps.hold_payment
1539: -- Subledger entry should exist for salesrep, credit_type and period
1540: -- cn_srp_periods
1541: -- Mandatory parameters check for payrun_id, salesrep_id
1542: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.payrun_id,

Line 2214: cn_salesreps cns,

2210: SELECT salesrep_id,ceil(rownum / c_batch_sz) FROM (SELECT DISTINCT cns.salesrep_id salesrep_id,
2211: cns.NAME salesrep_name
2212: FROM cn_payruns cnp,
2213: cn_srp_pay_groups cnspg,
2214: cn_salesreps cns,
2215: cn_period_statuses cnps
2216: WHERE cnp.payrun_id = c_payrun_id
2217: AND cnp.status = 'UNPAID'
2218: AND cnp.pay_group_id = cnspg.pay_group_id

Line 2299: cn_salesreps cns,

2295: FROM (SELECT DISTINCT cns.salesrep_id salesrep_id,
2296: cns.NAME salesrep_name
2297: FROM cn_payruns cnp,
2298: cn_srp_pay_groups cnspg,
2299: cn_salesreps cns,
2300: cn_period_statuses cnps
2301: WHERE cnp.payrun_id = l_payrun_id
2302: AND cnp.status = 'UNPAID'
2303: AND cnp.pay_group_id = cnspg.pay_group_id

Line 2443: l_srp_status cn_salesreps.status%TYPE;

2439: l_wk_plan_elements num_tab;
2440: l_has_access BOOLEAN;
2441: l_org_id NUMBER;
2442: l_pay_by_mode VARCHAR2(1);
2443: l_srp_status cn_salesreps.status%TYPE;
2444:
2445: BEGIN
2446: -- Standard Start of API savepoint
2447: SAVEPOINT update_worksheet;

Line 2496: FROM cn_salesreps s,

2492: r.payables_flag
2493: INTO l_srp_status,
2494: l_payroll_flag,
2495: l_payables_flag
2496: FROM cn_salesreps s,
2497: cn_repositories_all r,
2498: cn_payruns_all pr
2499: WHERE s.salesrep_id = wksht_rec.salesrep_id
2500: AND s.org_id = r.org_id