APPS.CN_PMT_TRANS_PVT dependencies on CN_PAYRUNS

Line 500: p_payrun_id cn_payruns.payrun_id%TYPE,

496: pmt_trans_rec_amount get_pmt_trans_amt%ROWTYPE;
497:
498: --bug 3114349, issue 3.
499: CURSOR get_waive_quota_id (
500: p_payrun_id cn_payruns.payrun_id%TYPE,
501: p_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE
502: )
503: IS
504: SELECT -NVL (SUM (NVL (payment_amount, 0)), 0) payment_amount,

Line 514: p_payrun_id cn_payruns.payrun_id%TYPE,

510: AND incentive_type_code = 'PMTPLN_REC'
511: GROUP BY quota_id;
512:
513: CURSOR get_waive_flag (
514: p_payrun_id cn_payruns.payrun_id%TYPE,
515: p_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE
516: )
517: IS
518: SELECT NVL (waive_flag, 'N') waive_flag,

Line 1005: FROM cn_payruns

1001: CURSOR get_payrun
1002: IS
1003: SELECT pay_period_id,
1004: pay_date
1005: FROM cn_payruns
1006: WHERE payrun_id = p_payrun_id
1007: AND status = 'UNPAID';
1008:
1009: BEGIN

Line 1550: FROM cn_payruns cp,

1546: cpw.salesrep_id,
1547: --R12
1548: cpw.org_id,
1549: cpt.object_version_number ovn
1550: FROM cn_payruns cp,
1551: cn_payment_worksheets cpw,
1552: cn_payment_transactions cpt
1553: WHERE cpw.payment_worksheet_id = p_payment_worksheet_id
1554: AND cp.payrun_id = cpw.payrun_id