APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_SIMULATION_PLANS_VL

Line 4508: SELECT COUNT(*) FROM AHL_SIMULATION_PLANS_VL

4504:
4505: -- VWP11.5.10 Enhancements
4506: -- To find whether any visit which is in a primaryplan has any simulation plans
4507: CURSOR c_simulation (x_id IN NUMBER) IS
4508: SELECT COUNT(*) FROM AHL_SIMULATION_PLANS_VL
4509: WHERE SIMULATION_PLAN_ID = x_id
4510: AND PRIMARY_PLAN_FLAG = 'Y';
4511:
4512: -- AnRaj: Following two cursors have been changed due to performnace issues