APPS.AMS_APPROVAL_PVT dependencies on JTF_RS_ROLES_VL

Line 1074: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl

1070: AND active_flag = 'Y';
1071:
1072: CURSOR c_role_info IS
1073: SELECT rr.role_resource_id, rl.role_name
1074: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl
1075: WHERE rr.role_id = rl.role_id
1076: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1077: AND rr.delete_flag = 'N'
1078: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)