APPS.AMS_GEN_APPROVAL_PVT dependencies on JTF_RS_ROLES_VL

Line 237: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl

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