DBA Data[Home] [Help]

APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_VISITS_B

Line 547: FROM AHL_VISITS_B

543:
544: -- To find if this Unit has been planned in other visits already
545: CURSOR c_unit (x_unit_id IN NUMBER) IS
546: SELECT VISIT_NUMBER
547: FROM AHL_VISITS_B
548: WHERE VISIT_ID IN ( SELECT DISTINCT VISIT_ID
549: FROM AHL_VISIT_TASKS_B
550: WHERE Unit_Effectivity_Id = x_unit_id
551: )