APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SALESREPS

Line 233: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,

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

Line 375: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,

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

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

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

Line 2257: cn_salesreps cns,

2253: FROM (SELECT DISTINCT cns.salesrep_id salesrep_id,
2254: cns.NAME salesrep_name
2255: FROM cn_payruns cnp,
2256: cn_srp_pay_groups cnspg,
2257: cn_salesreps cns,
2258: cn_period_statuses cnps
2259: WHERE cnp.payrun_id = l_payrun_id
2260: AND cnp.status = 'UNPAID'
2261: AND cnp.pay_group_id = cnspg.pay_group_id

Line 2397: l_srp_status cn_salesreps.status%TYPE;

2393: l_wk_plan_elements num_tab;
2394: l_has_access BOOLEAN;
2395: l_org_id NUMBER;
2396: l_pay_by_mode VARCHAR2(1);
2397: l_srp_status cn_salesreps.status%TYPE;
2398:
2399: BEGIN
2400: -- Standard Start of API savepoint
2401: SAVEPOINT update_worksheet;

Line 2450: FROM cn_salesreps s,

2446: r.payables_flag
2447: INTO l_srp_status,
2448: l_payroll_flag,
2449: l_payables_flag
2450: FROM cn_salesreps s,
2451: cn_repositories_all r,
2452: cn_payruns_all pr
2453: WHERE s.salesrep_id = wksht_rec.salesrep_id
2454: AND s.org_id = r.org_id