APPS.CAC_SYNC_TASK_COMMON dependencies on JTF_RS_RESOURCE_EXTNS

Line 817: FROM jtf_rs_resource_extns

813: IS
814: CURSOR c_resource
815: IS
816: SELECT resource_id, 'RS_' || category
817: FROM jtf_rs_resource_extns
818: WHERE user_id = fnd_global.user_id;
819: BEGIN
820: OPEN c_resource;
821: FETCH c_resource INTO x_resource_id, x_resource_type;

Line 1946: FROM jtf_rs_resource_extns r, jtf_task_all_assignments a

1942: IS
1943: CURSOR c_assignment (b_task_id NUMBER, b_resource_id NUMBER)
1944: IS
1945: SELECT a.assignee_role, a.assignment_status_id, r.resource_id
1946: FROM jtf_rs_resource_extns r, jtf_task_all_assignments a
1947: WHERE a.task_id = b_task_id
1948: AND a.resource_id = b_resource_id
1949: AND r.user_id = a.created_by;
1950: