APPS.AHL_FLEET_FORECAST_PVT dependencies on AHL_UE_SIMULATIONS

Line 37: FROM AHL_UE_SIMULATIONS

33: -- Cursor for checking lock in ue table
34: CURSOR check_lock_ue_tbl(p_fleet_id NUMBER)
35: IS
36: SELECT 1
37: FROM AHL_UE_SIMULATIONS
38: WHERE fleet_header_id = p_fleet_id FOR UPDATE;
39: -- Cursor to pick fleets which are draft, has null completion date and has no mr associations
40: CURSOR applicable_draft_fleets(p_fleet_id NUMBER)
41: IS

Line 190: FROM AHL_UE_SIMULATIONS

186: FROM AHL_FLEET_UNIT_ASSOCS
187: WHERE fleet_header_id = p_fleet_id;
188: -- Delete UEs generated for the fleet
189: DELETE
190: FROM AHL_UE_SIMULATIONS
191: WHERE fleet_header_id = p_fleet_id;
192: -- Update fleet data in MR table
193: -- Note that we are not using OVN in where clause for this update
194: /* UPDATE AHL_MR_EFFECTIVITIES

Line 295: FROM AHL_UE_SIMULATIONS

291: RAISE FND_API.G_EXC_ERROR;
292: END IF;
293: -- Delete UEs generated for the fleet
294: DELETE
295: FROM AHL_UE_SIMULATIONS
296: WHERE fleet_header_id = p_fleet_id;
297: -- Delete fleet unit association
298: DELETE
299: FROM AHL_FLEET_UNIT_ASSOCS