APPS.AMS_APPROVAL_PVT dependencies on JTF_RS_ROLES_VL

Line 1110: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl

1106: AND active_flag = 'Y';
1107:
1108: CURSOR c_role_info IS
1109: SELECT rr.role_resource_id, rl.role_name
1110: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl
1111: WHERE rr.role_id = rl.role_id
1112: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1113: AND rr.delete_flag = 'N'
1114: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)