APPS.AMS_APPROVAL_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1074: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl

1070: AND active_flag = 'Y';
1071:
1072: CURSOR c_role_info IS
1073: SELECT rr.role_resource_id, rl.role_name
1074: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl
1075: WHERE rr.role_id = rl.role_id
1076: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1077: AND rr.delete_flag = 'N'
1078: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)

Line 1095: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl

1091: AND TRUNC(NVL(res_rl_end_date,SYSDATE));
1092: */
1093: CURSOR c_role_info_count IS
1094: SELECT COUNT(1)
1095: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
1096: WHERE rr.role_id = rl.role_id
1097: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1098: AND rr.delete_flag = 'N'
1099: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)

Line 1115: FROM jtf_rs_role_relations rr,

1111: AND TRUNC(NVL(res_rl_end_date,SYSDATE));
1112: */
1113: CURSOR c_default_role_info IS
1114: SELECT rr.role_id
1115: FROM jtf_rs_role_relations rr,
1116: jtf_rs_roles_b rl
1117: WHERE rr.role_id = rl.role_id
1118: AND rl.role_type_code IN( 'MKTGAPPR','AMSAPPR')
1119: AND rl.role_code = 'AMS_DEFAULT_APPROVER'

Line 7664: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl

7660: having count(approver_id) > 1);
7661:
7662: CURSOR c_is_requestor_def_appr IS
7663: SELECT rr.role_resource_id
7664: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
7665: WHERE rr.role_id = rl.role_id
7666: AND rr.role_resource_type = 'RS_INDIVIDUAL'
7667: AND rl.role_code = 'AMS_DEFAULT_APPROVER'
7668: AND rr.delete_flag = 'N'

Line 7675: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl

7671: AND rr.role_resource_id = p_requestor_id;
7672:
7673: CURSOR c_is_requestor_appr_role IS
7674: SELECT rr.role_resource_id
7675: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
7676: WHERE rr.role_id = rl.role_id
7677: AND rr.role_resource_type = 'RS_INDIVIDUAL'
7678: AND rr.delete_flag = 'N'
7679: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)