DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on HZ_LOCATIONS

Line 324: , hz_locations hl

320: , jtf_tasks_tl tl
321: , jtf_task_statuses_b sb
322: , jtf_task_statuses_tl sl
323: , hz_party_sites ps
324: , hz_locations hl
325: , hz_parties pi
326: , fnd_timezones_b tz
327: WHERE a.task_id = p_task_id
328: AND resource_id = p_resource_id

Line 1464: , hz_locations hl

1460: , jtf_tasks_tl tl
1461: , jtf_task_statuses_b sb
1462: , jtf_task_statuses_tl sl
1463: , hz_party_sites ps
1464: , hz_locations hl
1465: , hz_parties pi
1466: , fnd_timezones_b tz
1467: WHERE a.task_id = p_task_id
1468: AND resource_id = p_resource_id

Line 2434: , hz_locations hl

2430: , jtf_tasks_tl tl
2431: , jtf_task_statuses_b sb
2432: , jtf_task_statuses_tl sl
2433: , hz_party_sites ps
2434: , hz_locations hl
2435: , hz_parties pi
2436: , fnd_timezones_b tz
2437: WHERE a.task_id = p_task_id
2438: AND resource_id = p_resource_id

Line 3161: , hz_locations hl

3157: , jtf_tasks_tl tl
3158: , jtf_task_statuses_b sb
3159: , jtf_task_statuses_tl sl
3160: , hz_party_sites ps
3161: , hz_locations hl
3162: , hz_parties pi
3163: , fnd_timezones_b tz
3164: WHERE a.task_id = p_task_id
3165: AND resource_id = p_resource_id

Line 5335: , hz_locations l

5331: , jtf_task_statuses_b tsb
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

Line 5429: , hz_locations l

5425: , jtf_task_statuses_b tsb
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

Line 6784: , hz_locations l

6780: , jtf_task_priorities_B jtp
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

Line 6864: , hz_locations l

6860: , jtf_task_priorities_B jtp
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

Line 7105: , hz_locations l

7101: , jtf_task_statuses_b tsb
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')

Line 7204: , hz_locations l

7200: , jtf_task_statuses_b tsb
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