APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_ROLES

Line 905: l_role_name cn_roles.name%TYPE;

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

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