APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_VISITS_B
Line 558: FROM AHL_VISITS_B
554:
555: -- To find if this Unit has been planned in other visits already
556: CURSOR c_unit (x_unit_id IN NUMBER) IS
557: SELECT VISIT_NUMBER 558: FROM AHL_VISITS_B 559: WHERE VISIT_ID IN ( SELECT DISTINCT VISIT_ID
560: FROM AHL_VISIT_TASKS_B
561: WHERE Unit_Effectivity_Id = x_unit_id
562: )