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.

[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_SRP_PMT_PLANS_ALL

Line 154: FROM cn_srp_pmt_plans_all

150: x_loading_status := p_loading_status ;
151:
152: -- Check if already exist( duplicate assigned,unique key violation check)
153: SELECT COUNT(1) INTO l_dummy
154: FROM cn_srp_pmt_plans_all
155: WHERE salesrep_id = p_salesrep_id
156: AND pmt_plan_id = p_pmt_plan_id
157: AND start_date = p_start_date
158: AND ( (end_date = p_end_date) OR

Line 286: FROM cn_srp_pmt_plans_all cspp, cn_pmt_plans_all cpp

282: -- Ensure pmt plan assignments do not overlap each other in same role
283: -- only 1 payment plan is active at each date
284: -- Returns an error message and raises an exception if overlap occurs.
285: SELECT COUNT(1) INTO l_dummy
286: FROM cn_srp_pmt_plans_all cspp, cn_pmt_plans_all cpp
287: WHERE (((cspp.end_date IS NULL)
288: AND (p_end_date IS NULL))
289: OR
290: ((cspp.end_date IS NULL) AND

Line 397: cn_payruns_all prun, cn_srp_pmt_plans_all spp

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
401: AND prun.org_id = prd.org_id

Line 415: cn_payruns_all prun, cn_srp_pmt_plans_all spp,cn_pmt_plans_all pp

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
419: AND prun.org_id = prd.org_id

Line 435: cn_payruns_all prun, cn_srp_pmt_plans_all spp,cn_pmt_plans_all pp

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
439: AND prun.pay_period_id = prd.period_id

Line 507: FROM cn_srp_pmt_plans_all

503: AND prd.end_date > l_fixed_end_date;
504:
505: CURSOR get_date_range(param_srp_pmt_plan_id NUMBER) IS
506: SELECT start_date, Nvl(end_date, l_end_of_time) as end_date
507: FROM cn_srp_pmt_plans_all
508: WHERE srp_pmt_plan_id = param_srp_pmt_plan_id;
509:
510: --Added by Christina------------------------------------------------------------
511: -- This cursor returns an error status if there are any paid/unpaid worksheets

Line 518: cn_payruns_all prun, cn_srp_pmt_plans_all spp

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
522: AND prun.pay_period_id = prd.period_id

Line 1021: FROM cn_srp_pmt_plans_all

1017:
1018: -- populate ovn
1019: SELECT object_version_number
1020: INTO p_pmt_plan_assign_rec.object_version_number
1021: FROM cn_srp_pmt_plans_all
1022: WHERE srp_pmt_plan_id = p_pmt_plan_assign_rec.srp_pmt_plan_id;
1023:
1024: -- End of API body
1025:

Line 1249: update cn_srp_pmt_plans_all

1245: ,x_role_pmt_plan_id => p_pmt_plan_assign_rec.role_pmt_plan_id
1246: ,x_lock_flag => p_pmt_plan_assign_rec.lock_flag);
1247:
1248: -- sync ID back
1249: update cn_srp_pmt_plans_all
1250: set srp_pmt_plan_id = l_oldrec.srp_pmt_plan_id
1251: where srp_pmt_plan_id = p_pmt_plan_assign_rec.srp_pmt_plan_id;
1252:
1253: p_pmt_plan_assign_rec.srp_pmt_plan_id := l_oldrec.srp_pmt_plan_id;

Line 1311: UPDATE cn_srp_pmt_plans_all

1307: );
1308:
1309: -- if the lock_flag is being set, then blow away role_pmt_plan_id
1310: IF p_pmt_plan_assign_rec.lock_flag = 'Y' THEN
1311: UPDATE cn_srp_pmt_plans_all
1312: SET role_pmt_plan_id = NULL,
1313: srp_role_id = NULL
1314: WHERE srp_pmt_plan_id = p_pmt_plan_assign_rec.srp_pmt_plan_id;
1315: END IF;

Line 1364: FROM cn_srp_pmt_plans_all

1360:
1361: -- pick up new object version number
1362: SELECT object_version_number
1363: INTO p_pmt_plan_assign_rec.object_version_number
1364: FROM cn_srp_pmt_plans_all
1365: WHERE srp_pmt_plan_id = p_pmt_plan_assign_rec.srp_pmt_plan_id;
1366: -- End of API body.
1367:
1368: -- Standard check of p_commit.

Line 1539: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all p, cn_role_pmt_plans_all rpp, cn_roles r

1535: l_pmt_plan_assign_rec pmt_plan_assign_rec;
1536:
1537: CURSOR spp_info_cur IS
1538: select p.name, r.name role_name, spp.start_date, spp.end_date, spp.minimum_amount, spp.maximum_amount, spp.lock_flag, spp.salesrep_id
1539: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all p, cn_role_pmt_plans_all rpp, cn_roles r
1540: where spp.srp_pmt_plan_id = p_srp_pmt_plan_id
1541: and spp.role_pmt_plan_id = rpp.role_pmt_plan_id(+)
1542: and spp.pmt_plan_id = p.pmt_plan_id
1543: and rpp.role_id = r.role_id(+);

Line 1965: --2.Full Table Scan. Added 1 index: create index cn_srp_pmt_plans_n1 ON cn_srp_pmt_plans_all(srp_role_id,org_id)

1961: IF (l_count <> 0)
1962: THEN
1963: --Bug 3670276 by Julia Huang on 6/4/04 to avoid the following
1964: --1.Cartesian join. Line changed: AND spp.role_pmt_plan_id = crpp.role_pmt_plan_id --p_role_pmt_plan_id
1965: --2.Full Table Scan. Added 1 index: create index cn_srp_pmt_plans_n1 ON cn_srp_pmt_plans_all(srp_role_id,org_id)
1966: select spp.start_date, spp.end_date, spp.salesrep_id,
1967: crpp.start_date, crpp.end_date, spp.srp_pmt_plan_id
1968: into l_start_date_old, l_end_date_old, l_salesrep_id_old,
1969: l_role_pp_start_date, l_role_pp_end_date, l_srp_pmt_plan_id

Line 1970: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all cpp, cn_role_pmt_plans_all crpp

1966: select spp.start_date, spp.end_date, spp.salesrep_id,
1967: crpp.start_date, crpp.end_date, spp.srp_pmt_plan_id
1968: into l_start_date_old, l_end_date_old, l_salesrep_id_old,
1969: l_role_pp_start_date, l_role_pp_end_date, l_srp_pmt_plan_id
1970: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all cpp, cn_role_pmt_plans_all crpp
1971: where spp.srp_role_id = p_srp_role_id
1972: AND spp.role_pmt_plan_id = crpp.role_pmt_plan_id --p_role_pmt_plan_id
1973: AND crpp.role_pmt_plan_id = p_role_pmt_plan_id
1974: AND cpp.pmt_plan_id = spp.pmt_plan_id;

Line 2045: cn_payruns_all prun, cn_srp_pmt_plans_all spp

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
2049: AND prun.org_id = prd.org_id

Line 2286: --2.Full Table Scan. Added 1 index: create index cn_srp_pmt_plans_n1 ON cn_srp_pmt_plans_all(srp_role_id,org_id)

2282: BEGIN
2283:
2284: --Bug 3670276 by Julia Huang on 6/4/04 to avoid the following
2285: --1.Cartesian join. Line changed: AND spp.role_pmt_plan_id = crpp.role_pmt_plan_id --p_role_pmt_plan_id
2286: --2.Full Table Scan. Added 1 index: create index cn_srp_pmt_plans_n1 ON cn_srp_pmt_plans_all(srp_role_id,org_id)
2287: select spp.start_date, spp.end_date, spp.salesrep_id,
2288: cpp.minimum_amount, cpp.maximum_amount,
2289: crpp.start_date, crpp.end_date, spp.srp_pmt_plan_id
2290: into l_start_date, l_end_date, l_salesrep_id,