DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on JTF_TASKS_B

Line 637: , jtf_tasks_b jtb

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
641: AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'

Line 687: , jtf_tasks_b jtb

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
691: AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'