APPS.AMS_APPROVERS_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1288: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl

1284: WHERE RESOURCE_ID = id_in);
1285: CURSOR c_rappr_id_exists(id_in IN NUMBER) IS
1286: SELECT 1 FROM dual
1287: WHERE EXISTS ( SELECT 1
1288: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
1289: WHERE rr.role_id = rl.role_id
1290: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1291: AND rr.delete_flag = 'N'
1292: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)

Line 1302: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl

1298: WHERE ROLE_ID = id_in);
1299: */
1300: CURSOR c_multi_appr_exists(id_in IN NUMBER) IS
1301: SELECT COUNT(1)
1302: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
1303: WHERE rr.role_id = rl.role_id
1304: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1305: AND rr.delete_flag = 'N'
1306: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)