APPS.JTF_TASK_WF_UTIL dependencies on JTF_RS_RESOURCE_EXTNS

Line 158: FROM jtf_rs_resource_extns

154:
155: PROCEDURE get_party_details(p_resource_id IN NUMBER, p_resource_type_code IN VARCHAR2, x_role_name OUT NOCOPY VARCHAR2) IS
156: CURSOR c_resource_party(b_resource_id jtf_tasks_b.owner_id%TYPE) IS
157: SELECT source_id
158: FROM jtf_rs_resource_extns
159: WHERE resource_id = b_resource_id;
160:
161: l_party_id hz_parties.party_id%TYPE;
162: l_display_name VARCHAR2(100); -- check this declaration

Line 187: FROM jtf_rs_resource_extns

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
189: FROM jtf_rs_group_members
190: WHERE GROUP_ID = b_group_id AND NVL(delete_flag, 'N') = 'N');
191:

Line 195: FROM jtf_rs_resource_extns

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
197: FROM jtf_rs_team_members
198: WHERE team_id = b_team_id AND NVL(delete_flag, 'N') = 'N');
199:

Line 569: FROM jtf_rs_resource_extns

565: WHERE task_status_id = b_status;
566:
567: CURSOR c_logged_res_id IS
568: SELECT resource_id
569: FROM jtf_rs_resource_extns
570: WHERE user_id = fnd_global.user_id;
571:
572: l_task_rec c_task_details%ROWTYPE;
573:

Line 595: l_logged_res_id jtf_rs_resource_extns.resource_id%TYPE;

591:
592: l_task_text VARCHAR2(1050);
593: l_backcomp_flag VARCHAR2(1);
594:
595: l_logged_res_id jtf_rs_resource_extns.resource_id%TYPE;
596:
597: l_wf_items VARCHAR2(500);
598: BEGIN
599: x_return_status := fnd_api.g_ret_sts_success;