APPS.AMS_GEN_APPROVAL_PVT dependencies on JTF_RS_ROLE_RELATIONS

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)

Line 257: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl

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

Line 275: FROM jtf_rs_role_relations rr,

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