APPS.JTF_TASK_WF_UTIL dependencies on JTF_RS_GROUP_MEMBERS

Line 184: CURSOR c_group_members(b_group_id jtf_rs_group_members.GROUP_ID%TYPE) IS

180: wf_directory.getusername('HZ_PARTY', l_party_id, x_role_name, l_display_name);
181: END get_party_details;
182:
183: PROCEDURE find_role(p_resource_id IN NUMBER, p_resource_type_code IN VARCHAR2) IS
184: CURSOR c_group_members(b_group_id jtf_rs_group_members.GROUP_ID%TYPE) IS
185: SELECT resource_id
186: , 'RS_' || CATEGORY resource_type_code
187: FROM jtf_rs_resource_extns
188: WHERE resource_id IN(SELECT resource_id

Line 189: FROM jtf_rs_group_members

185: SELECT resource_id
186: , 'RS_' || CATEGORY resource_type_code
187: FROM jtf_rs_resource_extns
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