APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_ROLE_PMT_PLANS_ALL

Line 913: from cn_roles r, cn_role_pmt_plans_all rpp

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

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

1536: l_pmt_plan_assign_rec pmt_plan_assign_rec;
1537:
1538: CURSOR spp_info_cur IS
1539: 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
1540: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all p, cn_role_pmt_plans_all rpp, cn_roles r
1541: where spp.srp_pmt_plan_id = p_srp_pmt_plan_id
1542: and spp.role_pmt_plan_id = rpp.role_pmt_plan_id(+)
1543: and spp.pmt_plan_id = p.pmt_plan_id
1544: and rpp.role_id = r.role_id(+);

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

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