APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_ROLE_PMT_PLANS_ALL

Line 912: from cn_roles r, cn_role_pmt_plans_all rpp

908: l_note_msg VARCHAR2(240);
909:
910: CURSOR get_role_name IS
911: select r.name
912: from cn_roles r, cn_role_pmt_plans_all rpp
913: where r.role_id = rpp.role_id
914: and rpp.role_pmt_plan_id = p_pmt_plan_assign_rec.role_pmt_plan_id;
915:
916: BEGIN

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