APPS.CSF_GANTT_DATA_PKG dependencies on JTF_TASK_DEPENDS

Line 2640: , jtf_task_depends jd

2636: , jtf_task_statuses_b tsb
2637: , jtf_task_statuses_b tsa
2638: , hz_parties pi
2639: , csf_access_hours_b ca
2640: , jtf_task_depends jd
2641: , jtf_task_depends jdd
2642: , csp_requirement_headers cr
2643: WHERE t.task_id = a.task_id
2644: AND t.source_object_type_code in( 'SR','TASK')

Line 2641: , jtf_task_depends jdd

2637: , jtf_task_statuses_b tsa
2638: , hz_parties pi
2639: , csf_access_hours_b ca
2640: , jtf_task_depends jd
2641: , jtf_task_depends jdd
2642: , csp_requirement_headers cr
2643: WHERE t.task_id = a.task_id
2644: AND t.source_object_type_code in( 'SR','TASK')
2645: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 2792: , jtf_task_depends jd

2788: , jtf_task_types_b tt
2789: , jtf_task_statuses_b tsb
2790: , jtf_task_statuses_b tsa
2791: , csf_access_hours_b ca
2792: , jtf_task_depends jd
2793: , jtf_task_depends jdd
2794: , csp_requirement_headers cr
2795: WHERE t.task_id = a.task_id
2796: AND t.source_object_type_code in( 'SR','TASK')

Line 2793: , jtf_task_depends jdd

2789: , jtf_task_statuses_b tsb
2790: , jtf_task_statuses_b tsa
2791: , csf_access_hours_b ca
2792: , jtf_task_depends jd
2793: , jtf_task_depends jdd
2794: , csp_requirement_headers cr
2795: WHERE t.task_id = a.task_id
2796: AND t.source_object_type_code in( 'SR','TASK')
2797: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 3840: , jtf_task_depends jd

3836: , jtf_tasks_b t
3837: , hz_parties pi
3838: , csf_access_hours_b ca
3839: , csp_requirement_headers cr
3840: , jtf_task_depends jd
3841: , jtf_task_depends jdd
3842: , jtf_task_statuses_b tsa
3843: , jtf_task_statuses_b tsb
3844: WHERE cpv.sched_request_id = p_req_id

Line 3841: , jtf_task_depends jdd

3837: , hz_parties pi
3838: , csf_access_hours_b ca
3839: , csp_requirement_headers cr
3840: , jtf_task_depends jd
3841: , jtf_task_depends jdd
3842: , jtf_task_statuses_b tsa
3843: , jtf_task_statuses_b tsb
3844: WHERE cpv.sched_request_id = p_req_id
3845: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)

Line 3954: , jtf_task_depends jd

3950: , jtf_task_assignments a
3951: , jtf_tasks_b t
3952: , csf_access_hours_b ca
3953: , csp_requirement_headers cr
3954: , jtf_task_depends jd
3955: , jtf_task_depends jdd
3956: , jtf_task_statuses_b tsa
3957: , jtf_task_statuses_b tsb
3958: WHERE cpv.sched_request_id = p_req_id

Line 3955: , jtf_task_depends jdd

3951: , jtf_tasks_b t
3952: , csf_access_hours_b ca
3953: , csp_requirement_headers cr
3954: , jtf_task_depends jd
3955: , jtf_task_depends jdd
3956: , jtf_task_statuses_b tsa
3957: , jtf_task_statuses_b tsb
3958: WHERE cpv.sched_request_id = p_req_id
3959: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)

Line 4137: , jtf_task_depends jd

4133: , jtf_task_statuses_b tsb
4134: , jtf_task_statuses_b tsa
4135: , hz_parties pi
4136: , csf_access_hours_b ca
4137: , jtf_task_depends jd
4138: , jtf_task_depends jdd
4139: , csp_requirement_headers cr
4140: WHERE t.task_id = a.task_id
4141: AND t.source_object_type_code in( 'SR','TASK')

Line 4138: , jtf_task_depends jdd

4134: , jtf_task_statuses_b tsa
4135: , hz_parties pi
4136: , csf_access_hours_b ca
4137: , jtf_task_depends jd
4138: , jtf_task_depends jdd
4139: , csp_requirement_headers cr
4140: WHERE t.task_id = a.task_id
4141: AND t.source_object_type_code in( 'SR','TASK')
4142: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 4299: , jtf_task_depends jd

4295: , jtf_task_types_b tt
4296: , jtf_task_statuses_b tsb
4297: , jtf_task_statuses_b tsa
4298: , csf_access_hours_b ca
4299: , jtf_task_depends jd
4300: , jtf_task_depends jdd
4301: , csp_requirement_headers cr
4302: WHERE t.task_id = a.task_id
4303: AND t.source_object_type_code in( 'SR','TASK')

Line 4300: , jtf_task_depends jdd

4296: , jtf_task_statuses_b tsb
4297: , jtf_task_statuses_b tsa
4298: , csf_access_hours_b ca
4299: , jtf_task_depends jd
4300: , jtf_task_depends jdd
4301: , csp_requirement_headers cr
4302: WHERE t.task_id = a.task_id
4303: AND t.source_object_type_code in( 'SR','TASK')
4304: AND NVL(t.deleted_flag, 'N') <> 'Y'