The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT activity_status
INTO l_activity_status
FROM wf_item_activity_statuses
WHERE item_type = itemtype
AND item_key = itemkey
AND process_activity IN (
select INSTANCE_ID
from WF_PROCESS_ACTIVITIES
where PROCESS_ITEM_TYPE = itemtype
and PROCESS_NAME = p_workflow_process
and INSTANCE_LABEL = p_block_label);
select NUMBER_VALUE
into lvalue
from WF_ITEM_ATTRIBUTE_VALUES
where ITEM_TYPE = p_item_type
and ITEM_KEY = p_item_key
and NAME = p_aname;