APPS.CAC_AVLBLTY_PUB dependencies on JTF_TASK_STATUSES_B

Line 306: , ( SELECT /*+ INDEX(jts JTF_TASK_STATUSES_B_U1) */ jts.task_status_id

302: , jtb.entity CategoryType
303: , jta.task_assignment_id
304: FROM jtf_task_all_assignments jta
305: , jtf_tasks_b jtb
306: , ( SELECT /*+ INDEX(jts JTF_TASK_STATUSES_B_U1) */ jts.task_status_id
307: FROM jtf_task_statuses_b jts
308: WHERE jts.assignment_status_flag = 'Y'
309: AND NVL(jts.closed_flag,'N') = 'N'
310: AND NVL(jts.completed_flag,'N') = 'N'

Line 307: FROM jtf_task_statuses_b jts

303: , jta.task_assignment_id
304: FROM jtf_task_all_assignments jta
305: , jtf_tasks_b jtb
306: , ( SELECT /*+ INDEX(jts JTF_TASK_STATUSES_B_U1) */ jts.task_status_id
307: FROM jtf_task_statuses_b jts
308: WHERE jts.assignment_status_flag = 'Y'
309: AND NVL(jts.closed_flag,'N') = 'N'
310: AND NVL(jts.completed_flag,'N') = 'N'
311: AND NVL(jts.rejected_flag,'N') = 'N'