APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on AHL_VISITS_B

Line 53: FROM AHL_VISITS_B

49: p_unit_schedule_id number
50: )
51: IS
52: SELECT *
53: FROM AHL_VISITS_B
54: WHERE unit_schedule_id = p_unit_schedule_id
55: AND STATUS_CODE NOT IN ('DELETED', 'CANCELLED' , 'CLOSED');
56:
57:

Line 1765: FROM AHL_VISITS_B

1761: CURSOR get_visit_for_flight_sch_csr (c_unit_schedule_id NUMBER) IS
1762: SELECT visit_id,
1763: start_date_time,
1764: close_date_time
1765: FROM AHL_VISITS_B
1766: WHERE unit_schedule_id = c_unit_schedule_id
1767: -- SATRAJEN :: Bug 14347661 :: To retrieve only Active Visits and Downtime Visits(Operational Visits):: 26-07-2012
1768: AND status_code NOT IN ('DELETED', 'CANCELLED', 'CLOSED')
1769: -- To support old flight schedules, assumpting NULL Visit as Downtime Visit to process further.