APPS.AHL_PRD_DF_PVT dependencies on AHL_SIMULATION_PLANS_B

Line 929: from ahl_visits_b vst, ahl_simulation_plans_b sim

925: FROM ahl_visit_tasks_b vts
926: WHERE vts.unit_effectivity_id = UE.unit_effectivity_id
927: AND NVL(vts.status_code,'x') IN ('PLANNED')
928: AND EXISTS (select 'x'
929: from ahl_visits_b vst, ahl_simulation_plans_b sim
930: where vst.simulation_plan_id = sim.simulation_plan_id(+)
931: and vst.visit_id = vts.visit_id
932: and sim.primary_plan_flag(+) = 'Y')
933: );