APPS.CN_WKSHT_CT_UP_PUB dependencies on CN_PAYRUNS

Line 28: --Cartesian join is caused by the lack of relationship between cn_payruns and cn_pmt_plans where cn_payruns

24: l_api_name CONSTANT VARCHAR2(30) := 'Create_delete_Wrkhst';
25: l_api_version CONSTANT NUMBER := 1.0;
26:
27: --Bug 3670308 by Julia Huang on 6/4/04
28: --Cartesian join is caused by the lack of relationship between cn_payruns and cn_pmt_plans where cn_payruns
29: --and cn_pmt_plans are driving tables as determined by the CBO.
30: CURSOR get_wksht IS
31: /*
32: SELECT pw.payment_worksheet_id,

Line 35: cn_payruns p,

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
39: and p.payrun_id = p_payrun_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 637: cn_payruns p,

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
641: and p.payrun_id = p_payrun_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