DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on JTF_TASKS_TL

Line 638: , jtf_tasks_tl jtt

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

Line 688: , jtf_tasks_tl jtt

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