APPS.CSF_GANTT_DATA_PKG dependencies on CSF_ACCESS_HOURS_B

Line 5336: , csf_access_hours_b ca

5332: , jtf_task_statuses_b tsa
5333: , hz_parties pi
5334: , hz_party_sites ps
5335: , hz_locations l
5336: , csf_access_hours_b ca
5337: , csp_requirement_headers cr
5338: WHERE t.task_id = a.task_id
5339: AND tl.task_id =t.task_id
5340: AND tl.language=userenv('LANG')

Line 5430: , csf_access_hours_b ca

5426: , jtf_task_statuses_b tsa
5427: , hz_parties pi
5428: , hz_party_sites ps
5429: , hz_locations l
5430: , csf_access_hours_b ca
5431: , jtf_task_depends jd
5432: , jtf_task_depends jdd
5433: , csp_requirement_headers cr
5434: WHERE t.task_id = a.task_id

Line 5512: , csf_access_hours_b ca

5508: , jtf_tasks_b t
5509: , jtf_task_types_b tt
5510: , jtf_task_statuses_b tsb
5511: , jtf_task_statuses_b tsa
5512: , csf_access_hours_b ca
5513: , csp_requirement_headers cr
5514: WHERE t.task_id = a.task_id
5515: AND t.source_object_type_code in( 'SR','TASK')
5516: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 5585: , csf_access_hours_b ca

5581: , jtf_tasks_b t
5582: , jtf_task_types_b tt
5583: , jtf_task_statuses_b tsb
5584: , jtf_task_statuses_b tsa
5585: , csf_access_hours_b ca
5586: , jtf_task_depends jd
5587: , jtf_task_depends jdd
5588: , csp_requirement_headers cr
5589: WHERE t.task_id = a.task_id

Line 6785: , csf_access_hours_b ca

6781: , jtf_task_priorities_tl jtpl
6782: , hz_parties pi
6783: , hz_party_sites ps
6784: , hz_locations l
6785: , csf_access_hours_b ca
6786: , csp_requirement_headers cr
6787: , jtf_task_statuses_b tsa
6788: , jtf_task_statuses_b tsb
6789: WHERE cpv.sched_request_id = p_req_id

Line 6865: , csf_access_hours_b ca

6861: , jtf_task_priorities_tl jtpl
6862: , hz_parties pi
6863: , hz_party_sites ps
6864: , hz_locations l
6865: , csf_access_hours_b ca
6866: , csp_requirement_headers cr
6867: , jtf_task_depends jd
6868: , jtf_task_depends jdd
6869: , jtf_task_statuses_b tsa

Line 6937: , csf_access_hours_b ca

6933: , NVL(child_position, 'N') child_task
6934: FROM csf_plan_options_v cpv
6935: , jtf_task_assignments a
6936: , jtf_tasks_b t
6937: , csf_access_hours_b ca
6938: , csp_requirement_headers cr
6939: , jtf_task_statuses_b tsa
6940: , jtf_task_statuses_b tsb
6941: WHERE cpv.sched_request_id = p_req_id

Line 6992: , csf_access_hours_b ca

6988: , NVL(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
6989: FROM csf_plan_options_v cpv
6990: , jtf_task_assignments a
6991: , jtf_tasks_b t
6992: , csf_access_hours_b ca
6993: , csp_requirement_headers cr
6994: , jtf_task_depends jd
6995: , jtf_task_depends jdd
6996: , jtf_task_statuses_b tsa

Line 7106: , csf_access_hours_b ca

7102: , jtf_task_statuses_b tsa
7103: , hz_parties pi
7104: , hz_party_sites ps
7105: , hz_locations l
7106: , csf_access_hours_b ca
7107: , csp_requirement_headers cr
7108: WHERE t.task_id = a.task_id
7109: AND t.source_object_type_code in( 'SR','TASK')
7110: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 7205: , csf_access_hours_b ca

7201: , jtf_task_statuses_b tsa
7202: , hz_parties pi
7203: , hz_party_sites ps
7204: , hz_locations l
7205: , csf_access_hours_b ca
7206: , jtf_task_depends jd
7207: , jtf_task_depends jdd
7208: , csp_requirement_headers cr
7209: WHERE t.task_id = a.task_id

Line 7293: , csf_access_hours_b ca

7289: , jtf_tasks_b t
7290: , jtf_task_types_b tt
7291: , jtf_task_statuses_b tsb
7292: , jtf_task_statuses_b tsa
7293: , csf_access_hours_b ca
7294: , csp_requirement_headers cr
7295: WHERE t.task_id = a.task_id
7296: AND t.source_object_type_code in( 'SR','TASK')
7297: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 7371: , csf_access_hours_b ca

7367: , jtf_tasks_b t
7368: , jtf_task_types_b tt
7369: , jtf_task_statuses_b tsb
7370: , jtf_task_statuses_b tsa
7371: , csf_access_hours_b ca
7372: , jtf_task_depends jd
7373: , jtf_task_depends jdd
7374: , csp_requirement_headers cr
7375: WHERE t.task_id = a.task_id