APPS.JTF_TASK_WF_UTIL dependencies on JTF_RS_GROUP_MEMBERS

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

213:
214: END get_party_details;
215:
216: PROCEDURE find_role(p_resource_id IN NUMBER, p_resource_type_code IN VARCHAR2) IS
217: CURSOR c_group_members(b_group_id jtf_rs_group_members.GROUP_ID%TYPE) IS
218: SELECT resource_id
219: , 'RS_' || CATEGORY resource_type_code
220: FROM jtf_rs_resource_extns
221: WHERE resource_id IN(SELECT resource_id

Line 222: FROM jtf_rs_group_members

218: SELECT resource_id
219: , 'RS_' || CATEGORY resource_type_code
220: FROM jtf_rs_resource_extns
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