The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(*)
FROM wf_item_activity_statuses w, wf_process_activities wpa
WHERE w.item_type = l_wf_item_type
AND w.process_activity = wpa.instance_id
AND wpa.activity_name = l_wf_activity_name
AND w.activity_status = l_wf_activity_status_code
AND w.item_key IN
( SELECT b.LINE_ID || ''
FROM OE_AK_ORDER_LINES_V b
WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
);
SELECT count(*)
FROM OE_AK_ORDER_LINES_V b
WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
;