The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT primary_uom_code
INTO p_primary_uom_code
FROM mtl_system_items
WHERE organization_id = p_organization_id
AND inventory_item_id = p_inventory_item_id;
SELECT uom_code
INTO p_txn_uom_code
FROM mtl_item_uoms_view
WHERE organization_id = p_organization_id
AND inventory_item_id = p_inventory_item_id
AND unit_of_measure = p_txn_unit_of_measure;