APPS.AMS_GEN_APPROVAL_PVT dependencies on JTF_RS_ROLES_B

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

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