APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_VISITS_B

Line 651: SELECT visit_id FROM ahl_visits_b

647: SELECT instance_id FROM csi_item_instances
648: WHERE instance_number = p_instance_number;
649:
650: CURSOR ahl_visit(p_visit_number IN NUMBER) IS
651: SELECT visit_id FROM ahl_visits_b
652: WHERE visit_number = p_visit_number;
653: -- Begin Changes by VSUNDARA
654: -- TO validate the Instance Owner
655: CURSOR ahl_instance_owner(p_instance_number IN VARCHAR2) IS