eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_PAYMENT_WORKSHEETS_ALL

Line 396: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

392: l_null_amount NUMBER := -9999;
393:
394: CURSOR get_del_payruns IS
395: SELECT DISTINCT prun.name
396: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
397: cn_payruns_all prun, cn_srp_pmt_plans_all spp
398: WHERE w.salesrep_id = spp.salesrep_id
399: AND w.quota_id is null
400: AND prun.pay_period_id = prd.period_id

Line 414: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

410: );
411:
412: CURSOR get_paid_del_payruns IS
413: SELECT 'ERROR' as estatus
414: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
415: cn_payruns_all prun, cn_srp_pmt_plans_all spp,cn_pmt_plans_all pp
416: WHERE w.salesrep_id = spp.salesrep_id
417: AND w.quota_id is null
418: AND prun.pay_period_id = prd.period_id

Line 434: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

430: );
431:
432: CURSOR get_adj_del_payruns IS
433: SELECT 'ERROR' as estatus
434: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
435: cn_payruns_all prun, cn_srp_pmt_plans_all spp,cn_pmt_plans_all pp
436: -- cn_payment_transactions pt
437: WHERE w.salesrep_id = spp.salesrep_id
438: AND w.quota_id is null

Line 459: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun

455:
456:
457: CURSOR get_upd_payruns IS
458: SELECT DISTINCT prun.name
459: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun
460: WHERE w.salesrep_id = p_salesrep_id
461: AND prun.pay_period_id = prd.period_id
462: AND w.quota_id is null
463: AND prun.org_id = prd.org_id

Line 470: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun

466: AND prd.start_date < p_start_date
467: AND prd.end_date > l_old_start_date
468: UNION
469: SELECT DISTINCT prun.name
470: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun
471: WHERE w.salesrep_id = p_salesrep_id
472: AND prun.pay_period_id = prd.period_id
473: AND prun.org_id = prd.org_id
474: AND w.quota_id is null

Line 482: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun

478: AND prd.end_date > l_fixed_end_date;
479:
480: CURSOR get_paid_upd_payruns IS
481: SELECT 'ERROR' as estatus
482: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun
483: WHERE w.salesrep_id = p_salesrep_id
484: AND prun.pay_period_id = prd.period_id
485: AND w.quota_id is null
486: AND prun.org_id = prd.org_id

Line 494: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun

490: AND prd.start_date < p_start_date
491: AND prd.end_date > l_old_start_date
492: UNION
493: SELECT 'ERROR' as estatus
494: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun
495: WHERE w.salesrep_id = p_salesrep_id
496: AND prun.pay_period_id = prd.period_id
497: AND prun.org_id = prd.org_id
498: AND prun.status = 'PAID'

Line 517: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

513: -- the date range that the user is trying to shrink the pp assignment to.
514:
515: CURSOR get_adj_upd_payruns IS
516: SELECT 'ERROR' as estatus
517: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
518: cn_payruns_all prun, cn_srp_pmt_plans_all spp
519: -- cn_payment_transactions pt
520: WHERE w.salesrep_id = spp.salesrep_id
521: AND w.quota_id is null

Line 677: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

673: -- Bug fix 2518847
674: --***********************************************************************
675:
676: SELECT COUNT(1) INTO l_dummy
677: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
678: cn_payruns_all prun, cn_payment_transactions_all pmttrans
679: WHERE w.salesrep_id = p_salesrep_id
680: AND w.salesrep_id = pmttrans.credited_salesrep_id
681: AND pmttrans.incentive_type_code = 'PMTPLN'

Line 721: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun

717: (p_old_end_date > p_end_date))
718: OR
719: ((p_old_end_date IS NULL) AND (p_end_date IS NOT NULL)) ) THEN
720: SELECT COUNT(1) INTO l_dummy
721: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun
722: WHERE w.salesrep_id = p_salesrep_id
723: AND prun.pay_period_id = prd.period_id
724: AND prun.org_id = prd.org_id
725: AND prun.payrun_id = w.payrun_id

Line 751: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun

747:
748: IF p_old_start_date <> p_start_date
749: THEN
750: SELECT COUNT(1) INTO l_dummy
751: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,cn_payruns_all prun
752: WHERE w.salesrep_id = p_salesrep_id
753: AND prun.pay_period_id = prd.period_id
754: AND prun.org_id = prd.org_id
755: AND prun.payrun_id = w.payrun_id

Line 2044: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

2040:
2041: if (l_count>0) then
2042:
2043: SELECT count(*) into l_worksheets
2044: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
2045: cn_payruns_all prun, cn_srp_pmt_plans_all spp
2046: WHERE w.salesrep_id = spp.salesrep_id
2047: AND w.quota_id is null
2048: AND prun.pay_period_id = prd.period_id

Line 2333: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

2329: CLOSE spp_csr;
2330:
2331:
2332: SELECT COUNT(1) INTO l_dummy
2333: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
2334: cn_payruns_all prun, cn_payment_transactions_all pmttrans
2335: WHERE w.salesrep_id = l_spp_rec.salesrep_id
2336: AND w.salesrep_id = pmttrans.credited_salesrep_id
2337: AND pmttrans.incentive_type_code = 'PMTPLN'