APPS.AMS_GEN_APPROVAL_PVT dependencies on JTF_RS_ROLES_B

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 278: jtf_rs_roles_b rl

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'
282: AND rr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'