APPS.AML_MONITOR_WF dependencies on JTF_RS_GROUP_MEMBERS

Line 2572: FROM JTF_RS_GROUP_MEMBERS mem,

2568: AND res.user_id = fnd_global.user_id;
2569:
2570: CURSOR c_get_group_id(c_resource_id NUMBER) IS
2571: SELECT grp.group_id
2572: FROM JTF_RS_GROUP_MEMBERS mem,
2573: JTF_RS_ROLE_RELATIONS rrel,
2574: JTF_RS_ROLES_B role,
2575: JTF_RS_GROUP_USAGES u,
2576: JTF_RS_GROUPS_B grp

Line 2593: -- A resource may not be in any group. Besides, jtf_rs_group_members

2589: AND SYSDATE BETWEEN grp.start_date_active AND
2590: NVL(grp.end_date_active,SYSDATE)
2591: AND ROWNUM < 2;
2592:
2593: -- A resource may not be in any group. Besides, jtf_rs_group_members
2594: -- may not have person_id for all resources. Therefore, get person_id
2595: -- in this cursor, instead of in the above cursor.
2596: CURSOR c_get_person_id(c_resource_id NUMBER) IS
2597: SELECT res.source_id