APPS.AMS_GEN_APPROVAL_PVT dependencies on JTF_RS_ROLE_RELATIONS

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)

Line 259: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl

255: and TRUNC(nvl(RES_RL_END_DATE,sysdate));
256: */
257: CURSOR c_role_info_count IS
258: SELECT count(1)
259: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
260: WHERE rr.role_id = rl.role_id
261: AND rr.role_resource_type = 'RS_INDIVIDUAL'
262: AND rr.delete_flag = 'N'
263: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)

Line 277: FROM jtf_rs_role_relations rr,

273: AND TRUNC(sysdate) between TRUNC(RES_RL_start_DATE) and TRUNC(nvl(RES_RL_END_DATE,sysdate));
274: */
275: CURSOR c_default_role_info IS
276: SELECT rr.role_id
277: FROM jtf_rs_role_relations rr,
278: jtf_rs_roles_b rl
279: WHERE rr.role_id = rl.role_id
280: and rl.role_type_code in( 'MKTGAPPR','AMSAPPR')
281: AND rl.role_code = 'AMS_DEFAULT_APPROVER'