APPS.AHL_VWP_VISITS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 4759: FROM ahl_unit_effectivities_b UE, ahl_visit_tasks_b VT

4755: -- If there are any which is in wrong status, can not close visit
4756: -- PLANNED tasks can not be canncelled. UMP enforcing that rule
4757: CURSOR get_ue_tasks_csr (p_visit_id IN NUMBER) IS
4758: SELECT UE.unit_effectivity_id
4759: FROM ahl_unit_effectivities_b UE, ahl_visit_tasks_b VT
4760: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
4761: AND nvl(UE.status_code,'x') NOT IN
4762: ('ACCOMPLISHED','DEFERRED','TERMINATED','CANCELLED')
4763: AND (VT.task_type_code = 'UNPLANNED' OR VT.task_type_code = 'PLANNED')