The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT client_id
FROM wsh_delivery_details
WHERE delivery_detail_id = p_delivery_detail_id;
SELECT requested_quantity_uom, requested_quantity_uom2
INTO l_requested_quantity_uom, l_requested_quantity_uom2
FROM wsh_delivery_details
WHERE delivery_detail_id = p_detail_tab(i).entity_id;
l_dd_id_tab.DELETE;