APPS.AHL_VWP_RULES_PVT dependencies on AHL_SIMULATION_PLANS_VL

Line 665: FROM ahl_simulation_plans_vl ASP

661: AHL_VISITS_VL WHERE VISIT_ID = x_id;
662: /*
663: CURSOR c_sim_visit(x_id IN NUMBER) IS
664: SELECT 'x'
665: FROM ahl_simulation_plans_vl ASP
666: WHERE primary_plan_flag = 'Y'
667: AND EXISTS ( SELECT 1
668: FROM ahl_visits_b
669: WHERE visit_id = x_id

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

687: L_DEBUG_KEY,
688: 'Simulation Id Check' || l_simulation_plan);
689: END IF;
690: SELECT SIMULATION_PLAN_ID INTO l_simulation_plan_id
691: FROM AHL_SIMULATION_PLANS_VL WHERE primary_plan_flag = 'Y';
692:
693: IF l_simulation_plan_id = l_simulation_plan THEN
694: x_bln_flag := 'Y';
695: ELSE