APPS.JTA_SYNC_TASK_COMMON dependencies on JTF_RS_RESOURCE_EXTNS

Line 711: FROM jtf_rs_resource_extns

707: IS
708: CURSOR c_resource
709: IS
710: SELECT resource_id, 'RS_' || category
711: FROM jtf_rs_resource_extns
712: WHERE user_id = fnd_global.user_id;
713: BEGIN
714: OPEN c_resource;
715: FETCH c_resource INTO x_resource_id, x_resource_type;

Line 1621: FROM jtf_rs_resource_extns r, jtf_task_all_assignments a

1617: IS
1618: CURSOR c_assignment (b_task_id NUMBER, b_resource_id NUMBER)
1619: IS
1620: SELECT a.assignee_role, a.assignment_status_id, r.resource_id
1621: FROM jtf_rs_resource_extns r, jtf_task_all_assignments a
1622: WHERE a.task_id = b_task_id
1623: AND a.resource_id = b_resource_id
1624: AND r.user_id = a.created_by;
1625: