APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_SIMULATION_PLANS_VL

Line 2465: SELECT COUNT(*) FROM AHL_SIMULATION_PLANS_VL

2461:
2462: -- VWP11.5.10 Enhancements
2463: -- To find whether any visit which is in a primaryplan has any simulation plans
2464: CURSOR c_simulation (x_id IN NUMBER) IS
2465: SELECT COUNT(*) FROM AHL_SIMULATION_PLANS_VL
2466: WHERE SIMULATION_PLAN_ID = x_id
2467: AND PRIMARY_PLAN_FLAG = 'Y';
2468:
2469: -- AnRaj: Following two cursors have been changed due to performnace issues