APPS.AMS_GEN_APPROVAL_PVT dependencies on JTF_RS_ROLES_VL

Line 239: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl

235: and active_flag ='Y';
236:
237: CURSOR c_role_info IS
238: SELECT rr.role_resource_id, rl.role_name
239: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl
240: WHERE rr.role_id = rl.role_id
241: AND rr.role_resource_type = 'RS_INDIVIDUAL'
242: AND rr.delete_flag = 'N'
243: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)