APPS.CN_WKSHT_CT_UP_PUB dependencies on CN_PERIOD_STATUSES

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 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