APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UE_SIMULATIONS

Line 1544: DELETE FROM AHL_UE_SIMULATIONS

1540: G_PRIMARY_PLAN := 'N';
1541: G_SIMULATION_PLAN_ID := p_simulation_plan_id;
1542:
1543: --Delete sim UEs belonging to unit which are not not present in the sim plan now or are expired
1544: DELETE FROM AHL_UE_SIMULATIONS
1545: WHERE SIMULATION_PLAN_ID = p_simulation_plan_id
1546: AND UNIT_CONFIG_HEADER_ID NOT IN
1547: (SELECT DISTINCT FU.UNIT_CONFIG_HEADER_ID
1548: FROM AHL_FLEET_UNIT_ASSOCS FU,

Line 2523: FROM AHL_UE_SIMULATIONS UE, II

2519: AND SYSDATE BETWEEN TRUNC(NVL(ACTIVE_START_DATE,SYSDATE))
2520: AND TRUNC(NVL(ACTIVE_END_DATE, SYSDATE+1))
2521: )
2522: SELECT 1
2523: FROM AHL_UE_SIMULATIONS UE, II
2524: WHERE UE.csi_item_instance_id = II.INSTANCE_ID
2525: AND (status_code IS NULL OR status_code IN ('INIT-DUE','EXCEPTION'))
2526: AND UE.SIMULATION_PLAN_ID = G_SIMULATION_PLAN_ID
2527: FOR UPDATE OF status_code NOWAIT;