DBA Data[Home] [Help]

APPS.CAC_VIEW_AVAIL_PVT dependencies on JTF_TASKS_B

Line 229: , jtf_tasks_b jtb

225: , jtb.calendar_start_date StartDate
226: , jtb.calendar_end_date EndDate
227: , jtb.timezone_id TimezoneID
228: FROM jtf_task_all_assignments jta
229: , jtf_tasks_b jtb
230: , jtf_task_statuses_b jtsb
231: WHERE jta.resource_id = b_ResourceID -- 101272224
232: AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'
233: AND jta.task_id = jtb.task_id -- join to tasks_b

Line 488: , jtf_tasks_b jtb

484: , jtb.calendar_end_date EndDate
485: , jtb.timezone_id TimezoneID
486: , NVL(jta.free_busy_type,'BUSY') FreeBusyType
487: FROM jtf_task_all_assignments jta
488: , jtf_tasks_b jtb
489: , jtf_task_statuses_b jtsb
490: WHERE jta.resource_id = b_ResourceID -- 101272224
491: AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'
492: AND jta.task_id = jtb.task_id -- join to tasks_b