APPS.AMS_APPROVAL_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1110: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl

1106: AND active_flag = 'Y';
1107:
1108: CURSOR c_role_info IS
1109: SELECT rr.role_resource_id, rl.role_name
1110: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl
1111: WHERE rr.role_id = rl.role_id
1112: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1113: AND rr.delete_flag = 'N'
1114: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)

Line 1131: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl

1127: AND TRUNC(NVL(res_rl_end_date,SYSDATE));
1128: */
1129: CURSOR c_role_info_count IS
1130: SELECT COUNT(1)
1131: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
1132: WHERE rr.role_id = rl.role_id
1133: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1134: AND rr.delete_flag = 'N'
1135: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)

Line 1151: FROM jtf_rs_role_relations rr,

1147: AND TRUNC(NVL(res_rl_end_date,SYSDATE));
1148: */
1149: CURSOR c_default_role_info IS
1150: SELECT rr.role_id
1151: FROM jtf_rs_role_relations rr,
1152: jtf_rs_roles_b rl
1153: WHERE rr.role_id = rl.role_id
1154: AND rl.role_type_code IN( 'MKTGAPPR','AMSAPPR')
1155: AND rl.role_code = 'AMS_DEFAULT_APPROVER'

Line 7755: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl

7751: having count(approver_id) > 1);
7752:
7753: CURSOR c_is_requestor_def_appr IS
7754: SELECT rr.role_resource_id
7755: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
7756: WHERE rr.role_id = rl.role_id
7757: AND rr.role_resource_type = 'RS_INDIVIDUAL'
7758: AND rl.role_code = 'AMS_DEFAULT_APPROVER'
7759: AND rr.delete_flag = 'N'

Line 7766: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl

7762: AND rr.role_resource_id = p_requestor_id;
7763:
7764: CURSOR c_is_requestor_appr_role IS
7765: SELECT rr.role_resource_id
7766: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
7767: WHERE rr.role_id = rl.role_id
7768: AND rr.role_resource_type = 'RS_INDIVIDUAL'
7769: AND rr.delete_flag = 'N'
7770: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)