APPS.CN_ROLE_PLANS_PUB dependencies on CN_SRP_ROLES

Line 1000: from cn_srp_roles sr,

996: /* CURSOR l_cur IS
997: select sr.srp_role_id srp_role_id,
998: nvl(srd.job_title_id, G_MISS_JOB_TITLE) job_title_id,
999: nvl(srd.plan_activate_status, 'NOT_PUSHED') push_status
1000: from cn_srp_roles sr,
1001: cn_srp_role_dtls srd
1002: where role_id = p_role_id
1003: and srd.role_model_id is NULL
1004: -- CHANGED FOR MODELING IMPACT

Line 1011: FROM cn_srp_roles

1007: --CHANTHON:Added org id in the cursor
1008: CURSOR l_cur
1009: IS
1010: SELECT srp_role_id
1011: FROM cn_srp_roles
1012: WHERE role_id = p_role_id AND org_id = p_org_id;
1013:
1014: l_rec l_cur%ROWTYPE;
1015: l_return_status VARCHAR2 (2000);

Line 1078: from cn_srp_roles sr,

1074: /* CURSOR l_cur IS
1075: select sr.srp_role_id srp_role_id,
1076: nvl(srd.job_title_id, G_MISS_JOB_TITLE) job_title_id,
1077: nvl(srd.plan_activate_status, 'NOT_PUSHED') push_status
1078: from cn_srp_roles sr,
1079: cn_srp_role_dtls srd
1080: where role_id = p_role_id
1081: and srd.role_model_id is NULL
1082: -- CHANGED FOR MODELING IMPACT

Line 1087: FROM cn_srp_roles

1083: and sr.srp_role_id = srd.srp_role_id(+);*/
1084: CURSOR l_cur
1085: IS
1086: SELECT srp_role_id
1087: FROM cn_srp_roles
1088: WHERE role_id = p_role_id AND org_id = p_org_id;
1089:
1090: CURSOR l_cur_del
1091: IS

Line 1093: FROM cn_srp_roles

1089:
1090: CURSOR l_cur_del
1091: IS
1092: SELECT srp_role_id
1093: FROM cn_srp_roles
1094: WHERE role_id = p_role_id_old AND org_id = p_org_id_old;
1095:
1096: l_rec l_cur%ROWTYPE;
1097: l_rec_del l_cur_del%ROWTYPE;

Line 1201: FROM cn_srp_roles

1197: IS
1198: CURSOR l_cur
1199: IS
1200: SELECT srp_role_id
1201: FROM cn_srp_roles
1202: WHERE role_id = p_role_id AND org_id = p_org_id;
1203:
1204: l_rec l_cur%ROWTYPE;
1205: l_return_status VARCHAR2 (2000);