APPS.AHL_UA_COMMON_PVT dependencies on AHL_UNIT_SCHEDULES

Line 65: from ahl_unit_schedules

61: unit_schedule_id event_id,
62: G_EVENT_TYPE_FLIGHT event_type,
63: nvl(actual_departure_time, est_departure_time) event_start_time,
64: nvl(actual_arrival_time, est_arrival_time) event_end_time
65: from ahl_unit_schedules
66: where unit_config_header_id = p_unit_config_id
67: and
68: (
69: (

Line 138: from ahl_unit_schedules

134: unit_schedule_id event_id,
135: G_EVENT_TYPE_FLIGHT event_type,
136: est_departure_time event_start_time,
137: est_arrival_time event_end_time
138: from ahl_unit_schedules
139: where unit_config_header_id = p_unit_config_id
140: and
141: (
142: (

Line 409: from ahl_unit_schedules_v

405: p_start_time date
406: )
407: is
408: select *
409: from ahl_unit_schedules_v
410: where unit_config_header_id = p_unit_config_id
411: --Modifying to capture preceding overlapping flights too...
412: --and nvl(actual_arrival_time, est_arrival_time) <= p_start_time
413: --order by nvl(actual_arrival_time, est_arrival_time) desc;

Line 425: from ahl_unit_schedules_v

421: p_start_time date
422: )
423: is
424: select *
425: from ahl_unit_schedules_v
426: where unit_config_header_id = p_unit_config_id
427: --Modifying to capture preceding overlapping flights too...
428: --and est_arrival_time <= p_start_time
429: --order by est_arrival_time desc;

Line 2027: from ahl_unit_schedules_v

2023: p_end_time date
2024: )
2025: is
2026: select *
2027: from ahl_unit_schedules_v
2028: where unit_config_header_id = p_unit_config_id
2029: and nvl(actual_departure_time, est_departure_time) > p_end_time
2030: order by nvl(actual_departure_time, est_departure_time) asc, nvl(actual_arrival_time, est_arrival_time) asc;
2031:

Line 2040: from ahl_unit_schedules_v

2036: p_end_time date
2037: )
2038: is
2039: select *
2040: from ahl_unit_schedules_v
2041: where unit_config_header_id = p_unit_config_id
2042: and est_departure_time > p_end_time
2043: order by est_departure_time asc, est_arrival_time asc;
2044: