APPS.AS_LEAD_ROUTING_WF dependencies on JTF_RS_GROUP_MEMBERS

Line 261: FROM JTF_RS_GROUP_MEMBERS mem,

257: AND res.user_id = fnd_global.user_id;
258:
259: CURSOR c_get_group_id(c_resource_id NUMBER) IS
260: SELECT grp.group_id
261: FROM JTF_RS_GROUP_MEMBERS mem,
262: JTF_RS_ROLE_RELATIONS rrel,
263: JTF_RS_ROLES_B role,
264: JTF_RS_GROUP_USAGES u,
265: JTF_RS_GROUPS_B grp

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

278: AND SYSDATE BETWEEN grp.start_date_active AND
279: NVL(grp.end_date_active,SYSDATE)
280: AND ROWNUM < 2;
281:
282: -- A resource may not be in any group. Besides, jtf_rs_group_members
283: -- may not have person_id for all resources. Therefore, get person_id
284: -- in this cursor, instead of in the above cursor.
285: CURSOR c_get_person_id(c_resource_id NUMBER) IS
286: SELECT res.source_id