APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on AHL_VISITS_B

Line 428: SELECT 1 FROM ahl_visits_b

424: )
425: IS
426: -- Check for visit is scheduled
427: CURSOR Check_Sch_Visit_cur (c_visit_id IN NUMBER) IS
428: SELECT 1 FROM ahl_visits_b
429: WHERE visit_id = c_visit_id
430: AND (organization_id IS NULL
431: OR department_id IS NULL
432: OR start_date_time IS NULL);