APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on AHL_VISITS_B

Line 445: SELECT 1 FROM ahl_visits_b

441: )
442: IS
443: -- Check for visit is scheduled
444: CURSOR Check_Sch_Visit_cur (c_visit_id IN NUMBER) IS
445: SELECT 1 FROM ahl_visits_b
446: WHERE visit_id = c_visit_id
447: AND (organization_id IS NULL
448: OR department_id IS NULL
449: OR start_date_time IS NULL);