APPS.CN_WKSHT_CT_UP_PUB dependencies on CN_PAYMENT_WORKSHEETS

Line 34: FROM cn_payment_worksheets pw,

30: CURSOR get_wksht IS
31: /*
32: SELECT pw.payment_worksheet_id,
33: pw.salesrep_id
34: FROM cn_payment_worksheets pw,
35: cn_payruns p,
36: cn_srp_pmt_plans_v ppa
37: WHERE ppa.salesrep_id = p_salesrep_id
38: and ppa.srp_pmt_plan_id = p_srp_pmt_asgn_id

Line 48: FROM cn_payment_worksheets pw, cn_payruns p, cn_period_statuses ps

44: and p.status = 'UNPAID' ;
45: */
46: SELECT pw.payment_worksheet_id,
47: pw.salesrep_id
48: FROM cn_payment_worksheets pw, cn_payruns p, cn_period_statuses ps
49: WHERE pw.salesrep_id = p_salesrep_id
50: AND p.payrun_id = p_payrun_id
51: AND p.org_id = ps.org_id
52: AND ps.period_id = p.pay_period_id

Line 226: FROM cn_payment_worksheets pw, cn_payruns p, cn_period_statuses ps

222: CURSOR get_wksht IS
223: SELECT pw.payment_worksheet_id,
224: pw.salesrep_id,
225: p.object_version_number
226: FROM cn_payment_worksheets pw, cn_payruns p, cn_period_statuses ps
227: WHERE pw.salesrep_id = p_salesrep_id
228: AND p.payrun_id = p_payrun_id
229: AND ps.period_id = p.pay_period_id
230: AND pw.payrun_id = p.payrun_id

Line 423: FROM cn_payment_worksheets pw, cn_payruns p, cn_period_statuses ps

419: CURSOR get_wksht IS
420: SELECT pw.payment_worksheet_id,
421: pw.salesrep_id,
422: p.object_version_number
423: FROM cn_payment_worksheets pw, cn_payruns p, cn_period_statuses ps
424: WHERE pw.salesrep_id = p_salesrep_id
425: AND p.payrun_id = p_payrun_id
426: AND ps.period_id = p.pay_period_id
427: AND ps.org_id = p.org_id

Line 636: FROM cn_payment_worksheets pw,

632: CURSOR get_wksht IS
633: /*
634: SELECT pw.payment_worksheet_id,
635: pw.salesrep_id
636: FROM cn_payment_worksheets pw,
637: cn_payruns p,
638: cn_srp_pmt_plans_v ppa
639: WHERE ppa.salesrep_id = p_salesrep_id
640: and ppa.srp_pmt_plan_id = p_srp_pmt_asgn_id

Line 651: FROM cn_payment_worksheets pw, cn_payruns p, cn_period_statuses ps

647: */
648: SELECT pw.payment_worksheet_id,
649: pw.salesrep_id,
650: p.object_version_number
651: FROM cn_payment_worksheets pw, cn_payruns p, cn_period_statuses ps
652: WHERE pw.salesrep_id = p_salesrep_id
653: AND p.payrun_id = p_payrun_id
654: AND ps.period_id = p.pay_period_id
655: AND ps.org_id = p.org_id