APPS.CAC_VIEW_AVAIL_PVT dependencies on JTF_TASK_STATUSES_B

Line 222: )IS SELECT /*+ INDEX(jtsb JTF_TASK_STATUSES_B_U1) */

218: ( b_ResourceID IN NUMBER
219: , b_ResourceType IN VARCHAR2
220: , b_StartDate IN DATE
221: , b_EndDate IN DATE
222: )IS SELECT /*+ INDEX(jtsb JTF_TASK_STATUSES_B_U1) */
223: jtb.source_object_id ItemSourceID
224: , jtb.source_object_type_code ItemSourceCode
225: , jtb.calendar_start_date StartDate
226: , jtb.calendar_end_date EndDate

Line 230: , jtf_task_statuses_b jtsb

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
234: AND jtb.task_status_id = jtsb.task_status_id -- join to to task_status_b

Line 480: )IS SELECT /*+ INDEX(jtsb JTF_TASK_STATUSES_B_U1) */

476: ( b_ResourceID NUMBER
477: , b_ResourceType VARCHAR2
478: , b_StartDate DATE
479: , b_EndDate DATE
480: )IS SELECT /*+ INDEX(jtsb JTF_TASK_STATUSES_B_U1) */
481: jtb.source_object_id ItemSourceID
482: , jtb.source_object_type_code ItemSourceCode
483: , jtb.calendar_start_date StartDate
484: , jtb.calendar_end_date EndDate

Line 489: , jtf_task_statuses_b jtsb

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
493: AND jtb.task_status_id = jtsb.task_status_id -- join to to task_status_b