DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on JTF_TASK_STATUSES_B

Line 639: , jtf_task_statuses_b jtsb

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
641: AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'
642: AND jta.task_id = jtb.task_id -- join to tasks_b
643: AND jtb.task_status_id = jtsb.task_status_id -- join to task_status_b

Line 689: , jtf_task_statuses_b jtsb

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
691: AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'
692: AND jta.task_id = jtb.task_id -- join to tasks_b
693: AND jtb.task_status_id = jtsb.task_status_id -- join to task_status_b