DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on JTF_TASK_TYPES_B

Line 2471: , jtf_task_types_b tt

2467: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2468: ) res_info
2469: , jtf_task_assignments a
2470: , jtf_tasks_b t
2471: , jtf_task_types_b tt
2472: , jtf_task_statuses_b tsa
2473: , jtf_task_statuses_b tsb
2474: WHERE t.task_id = a.task_id
2475: AND t.task_type_id = tt.task_type_id

Line 2558: , jtf_task_types_b tt

2554: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2555: ) res_info
2556: , jtf_task_assignments a
2557: , jtf_tasks_b t
2558: , jtf_task_types_b tt
2559: , jtf_task_statuses_b tsb
2560: , jtf_task_statuses_b tsa
2561: , hz_parties pi
2562: , csf_access_hours_b ca

Line 2635: , jtf_task_types_b tt

2631: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2632: ) res_info
2633: , jtf_task_assignments a
2634: , jtf_tasks_b t
2635: , jtf_task_types_b tt
2636: , jtf_task_statuses_b tsb
2637: , jtf_task_statuses_b tsa
2638: , hz_parties pi
2639: , csf_access_hours_b ca

Line 2713: , jtf_task_types_b tt

2709: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2710: ) res_info
2711: , jtf_task_assignments a
2712: , jtf_tasks_b t
2713: , jtf_task_types_b tt
2714: , jtf_task_statuses_b tsb
2715: , jtf_task_statuses_b tsa
2716: , csf_access_hours_b ca
2717: , csp_requirement_headers cr

Line 2788: , jtf_task_types_b tt

2784: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2785: ) res_info
2786: , jtf_task_assignments a
2787: , jtf_tasks_b t
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

Line 4050: , jtf_task_types_b tt

4046: AND rt.sched_request_id = p_req_id
4047: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
4048: , jtf_task_assignments a
4049: , jtf_tasks_b t
4050: , jtf_task_types_b tt
4051: , jtf_task_statuses_b tsb
4052: , jtf_task_statuses_b tsa
4053: , hz_parties pi
4054: , csf_access_hours_b ca

Line 4132: , jtf_task_types_b tt

4128: AND rt.sched_request_id = p_req_id
4129: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
4130: , jtf_task_assignments a
4131: , jtf_tasks_b t
4132: , jtf_task_types_b tt
4133: , jtf_task_statuses_b tsb
4134: , jtf_task_statuses_b tsa
4135: , hz_parties pi
4136: , csf_access_hours_b ca

Line 4215: , jtf_task_types_b tt

4211: AND rt.sched_request_id = p_req_id
4212: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
4213: , jtf_task_assignments a
4214: , jtf_tasks_b t
4215: , jtf_task_types_b tt
4216: , jtf_task_statuses_b tsb
4217: , jtf_task_statuses_b tsa
4218: , csf_access_hours_b ca
4219: , csp_requirement_headers cr

Line 4295: , jtf_task_types_b tt

4291: AND rt.sched_request_id = p_req_id
4292: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
4293: , jtf_task_assignments a
4294: , jtf_tasks_b t
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