APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_PERIOD_STATUSES_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 678: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

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

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

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

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

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

Line 2046: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

2042: if (l_count>0) then
2043: /* commented below code by Naren to fix bug 12821986
2044:
2045: SELECT count(*) into l_worksheets
2046: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
2047: cn_payruns_all prun, cn_srp_pmt_plans_all spp
2048: WHERE w.salesrep_id = spp.salesrep_id
2049: AND w.quota_id is null
2050: AND prun.pay_period_id = prd.period_id

Line 2068: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

2064:
2065: /* Added by Naren to fix bug 12821986*/
2066:
2067: SELECT count(*) into l_worksheets
2068: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
2069: cn_payruns_all prun, cn_srp_pmt_plans_all spp
2070: WHERE w.salesrep_id = spp.salesrep_id
2071: AND w.quota_id is null
2072: AND prun.pay_period_id = prd.period_id

Line 2359: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

2355: CLOSE spp_csr;
2356:
2357:
2358: SELECT COUNT(1) INTO l_dummy
2359: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
2360: cn_payruns_all prun, cn_payment_transactions_all pmttrans
2361: WHERE w.salesrep_id = l_spp_rec.salesrep_id
2362: AND w.salesrep_id = pmttrans.credited_salesrep_id
2363: AND pmttrans.incentive_type_code = 'PMTPLN'