APPS.JTF_TASK_WF_UTIL dependencies on JTF_RS_TEAM_MEMBERS

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

188: WHERE resource_id IN(SELECT resource_id
189: FROM jtf_rs_group_members
190: WHERE GROUP_ID = b_group_id AND NVL(delete_flag, 'N') = 'N');
191:
192: CURSOR c_team_members(b_team_id jtf_rs_team_members.team_id%TYPE) IS
193: SELECT resource_id
194: , 'RS_' || CATEGORY resource_type_code
195: FROM jtf_rs_resource_extns
196: WHERE resource_id IN(SELECT team_resource_id

Line 197: FROM jtf_rs_team_members

193: SELECT resource_id
194: , 'RS_' || CATEGORY resource_type_code
195: FROM jtf_rs_resource_extns
196: WHERE resource_id IN(SELECT team_resource_id
197: FROM jtf_rs_team_members
198: WHERE team_id = b_team_id AND NVL(delete_flag, 'N') = 'N');
199:
200: 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
201: SELECT name