APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on AHL_VISIT_TASKS_B

Line 1785: FROM AHL_VISIT_TASKS_B

1781:
1782: -- Cursor to check if the given visit contains any planned MRs
1783: CURSOR chk_planned_mrs_csr (c_visit_id NUMBER) IS
1784: SELECT 'Y'
1785: FROM AHL_VISIT_TASKS_B
1786: WHERE visit_id = c_visit_id
1787: AND task_type_code = 'PLANNED'
1788: AND status_code NOT IN ('DELETED', 'CANCELLED', 'CLOSED');
1789: --