[Home] [Help]
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: )