APPS.JTF_TASK_WF_UTIL dependencies on JTF_RS_TEAM_MEMBERS

Line 225: CURSOR c_team_members(b_team_id jtf_rs_team_members.team_id%TYPE) IS

221: WHERE resource_id IN(SELECT resource_id
222: FROM jtf_rs_group_members
223: WHERE GROUP_ID = b_group_id AND NVL(delete_flag, 'N') = 'N');
224:
225: CURSOR c_team_members(b_team_id jtf_rs_team_members.team_id%TYPE) IS
226: SELECT resource_id
227: , 'RS_' || CATEGORY resource_type_code
228: FROM jtf_rs_resource_extns
229: WHERE resource_id IN(SELECT team_resource_id

Line 230: FROM jtf_rs_team_members

226: SELECT resource_id
227: , 'RS_' || CATEGORY resource_type_code
228: FROM jtf_rs_resource_extns
229: WHERE resource_id IN(SELECT team_resource_id
230: FROM jtf_rs_team_members
231: WHERE team_id = b_team_id AND NVL(delete_flag, 'N') = 'N');
232:
233: CURSOR c_group_team_role(b_orig_system wf_local_roles.orig_system%TYPE, b_orig_system_id wf_local_roles.orig_system_id%TYPE) IS
234: SELECT name