DBA Data[Home] [Help]

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: )