The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT header_id
INTO l_header_id
FROM oe_order_lines
WHERE line_id = to_number(itemkey);
SELECT PARENT.ACTIVITY_ITEM_TYPE, PARENT.ACTIVITY_NAME
INTO l_wf_item, l_wf_activity
FROM WF_ITEM_ACTIVITY_STATUSES IAS,
WF_PROCESS_ACTIVITIES CHILD,
WF_PROCESS_ACTIVITIES PARENT
WHERE CHILD.INSTANCE_ID = actid
AND CHILD.PROCESS_ITEM_TYPE = PARENT.ACTIVITY_ITEM_TYPE
AND CHILD.PROCESS_NAME = PARENT.ACTIVITY_NAME
AND PARENT.INSTANCE_ID = IAS.PROCESS_ACTIVITY
AND IAS.ITEM_TYPE = itemtype
AND IAS.ITEM_KEY = itemkey;