APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_ROLES

Line 906: l_role_name cn_roles.name%TYPE;

902: l_api_name CONSTANT VARCHAR2(30) := 'Create_Srp_Pmt_Plan';
903: l_api_version CONSTANT NUMBER := 1.0;
904: l_credit_type_id NUMBER;
905: l_name cn_pmt_plans.name%TYPE;
906: l_role_name cn_roles.name%TYPE;
907: l_loading_status VARCHAR2(2000);
908: x_note_id NUMBER;
909: l_note_msg VARCHAR2(240);
910:

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(+);