APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_SIMULATION_PLANS_B

Line 16068: FROM AHL_SIMULATION_PLANS_B

16064:
16065: -- get fleet for the unit on the date given.
16066: CURSOR get_primary_plan IS
16067: SELECT simulation_plan_id
16068: FROM AHL_SIMULATION_PLANS_B
16069: WHERE primary_plan_flag = 'Y'
16070: AND status_code = 'ACTIVE'
16071: -- AND nvl(simulation_type,'UMP') = 'UMP'; Removed NVL condition as primary plan is seeded with UMP.
16072: AND simulation_type = 'UMP';