APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_UMP_RESOURCE_REQMNTS

Line 6685: DELETE FROM AHL_UMP_RESOURCE_REQMNTS

6681: END IF;
6682: END IF;
6683:
6684: -- Delete UMP BOM data when UE is pushed to production (any status)
6685: DELETE FROM AHL_UMP_RESOURCE_REQMNTS
6686: WHERE object_type = 'UE'
6687: AND MAINTENANCE_REQMNT_ID IN (SELECT unit_effectivity_id FROM ahl_visit_tasks_b WHERE visit_id = p_visit_id);
6688:
6689: DELETE FROM AHL_UMP_MATERIAL_REQMNTS