eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UA_COMMON_PVT dependencies on AHL_UNIT_SCHEDULES_V

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: