APPS.AHL_VWP_RULES_PVT dependencies on AHL_SIMULATION_PLANS_VL

Line 671: FROM ahl_simulation_plans_vl ASP

667: AHL_VISITS_VL WHERE VISIT_ID = x_id;
668: /*
669: CURSOR c_sim_visit(x_id IN NUMBER) IS
670: SELECT 'x'
671: FROM ahl_simulation_plans_vl ASP
672: WHERE primary_plan_flag = 'Y'
673: AND EXISTS ( SELECT 1
674: FROM ahl_visits_b
675: WHERE visit_id = x_id

Line 697: FROM AHL_SIMULATION_PLANS_VL WHERE primary_plan_flag = 'Y';

693: L_DEBUG_KEY,
694: 'Simulation Id Check' || l_simulation_plan);
695: END IF;
696: SELECT SIMULATION_PLAN_ID INTO l_simulation_plan_id
697: FROM AHL_SIMULATION_PLANS_VL WHERE primary_plan_flag = 'Y';
698:
699: IF l_simulation_plan_id = l_simulation_plan THEN
700: x_bln_flag := 'Y';
701: ELSE