APPS.AHL_PRD_DF_PVT dependencies on AHL_SIMULATION_PLANS_B

Line 956: from ahl_visits_b vst, ahl_simulation_plans_b sim

952: WHERE vts.unit_effectivity_id = UE.unit_effectivity_id
953: AND NVL(vts.status_code,'x') IN ('PLANNING')
954: AND vts.task_type_code = 'SUMMARY'
955: AND EXISTS (select 'x'
956: from ahl_visits_b vst, ahl_simulation_plans_b sim
957: where vst.simulation_plan_id = sim.simulation_plan_id(+)
958: and vst.visit_id = vts.visit_id
959: and sim.primary_plan_flag(+) = 'Y')
960: );