APPS.CAC_VIEW_PVT dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 11: FROM jtf_task_all_assignments jta

7: RETURN VARCHAR2
8: IS
9: CURSOR c_locations IS
10: SELECT resource_id
11: FROM jtf_task_all_assignments jta
12: WHERE jta.resource_type_code = 'PN_LOCATION'
13: AND jta.task_id = p_task_id;
14:
15: CURSOR c_standalone_location IS

Line 357: jtf_task_all_assignments booking,

353: jtf_task_statuses_vl booking_status,
354: jtf_task_types_tl task_type,
355: jtf_task_priorities_tl task_priority,
356: jtf_rs_resource_extns owner,
357: jtf_task_all_assignments booking,
358: fnd_lookups freebusy,
359: jtf_objects_tl jtf_object
360: WHERE
361: booking.resource_id = b_ResourceId --10125

Line 636: FROM jtf_task_all_assignments jta

632: ,1
633: ) RepeatIndicator
634: , jta.assignee_role AssigneeRole
635: , jta.free_busy_type free_busy_type
636: FROM jtf_task_all_assignments jta
637: , jtf_tasks_b jtb
638: , jtf_tasks_tl jtt
639: , jtf_task_statuses_b jtsb
640: WHERE jta.resource_id = b_ResourceID -- 101272224

Line 686: FROM jtf_task_all_assignments jta

682: ,NULL,0
683: ,1
684: ) RepeatIndicator
685: , jta.assignee_role AssigneeRole
686: FROM jtf_task_all_assignments jta
687: , jtf_tasks_b jtb
688: , jtf_tasks_tl jtt
689: , jtf_task_statuses_b jtsb
690: WHERE jta.resource_id = b_ResourceID -- 101272224

Line 758: jtf_task_all_assignments assignment,

754: hz_parties party,
755: hz_party_sites site,
756: hz_locations location,
757: jtf_rs_resource_extns owner,
758: jtf_task_all_assignments assignment,
759: jtf_objects_tl jtf_object
760: WHERE
761: assignment.resource_id = b_ResourceId --13475
762: AND assignment.resource_type_code = b_ResourceType --'RS_EMPLOYEE'

Line 786: from jtf_task_all_assignments

782: AND jtf_object.language = userenv('LANG')
783: AND task_view.owner_id = owner.resource_id --owner
784: AND task_view.owner_type_code = 'RS_' || owner.category
785: AND assignment.ASSIGNEE_ROLE= decode (1, (select count(task_assignment_id)
786: from jtf_task_all_assignments
787: where task_id=task_view.task_id
788: and resource_id = b_ResourceId
789: and resource_type_code=b_ResourceType),
790: assignment.ASSIGNEE_ROLE,'ASSIGNEE')