The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT item_type_code,shippable_flag,top_model_line_id, service_reference_type_code
INTO l_item_type,l_shippable_flag,l_top_model_line_id, l_service_reference_type_code
FROM oe_order_lines_all
WHERE line_id = to_number(itemkey);
SELECT header_id,service_reference_line_id
INTO l_header_id,l_service_ref_line_id
FROM oe_order_lines_all
WHERE line_id = to_number(itemkey)
AND service_reference_type_code = 'ORDER';
SELECT header_id,shippable_flag
INTO l_service_header_id,l_service_ship_flag
FROM oe_order_lines_all
WHERE line_id = l_service_ref_line_id;
SELECT WIAS.Activity_Status
INTO l_activity_status
FROM wf_item_activity_statuses WIAS,
wf_process_activities WPA
WHERE WIAS.Process_Activity = WPA.instance_id
AND WPA.activity_name = 'FULFILL_LINE_ELIGIBLE'
AND WIAS.item_type = 'OEOL'
AND WIAS.item_key = to_char(p_line_id)
AND WIAS.activity_status = 'NOTIFIED' ;
SELECT header_id
,order_source_id
,orig_sys_document_ref
,orig_sys_line_ref
,orig_sys_shipment_ref
,change_sequence
,source_document_type_id
,source_document_id
,source_document_line_id
INTO l_header_id
,l_order_source_id
,l_orig_sys_document_ref
,l_orig_sys_line_ref
,l_orig_sys_shipment_ref
,l_change_sequence
,l_source_document_type_id
,l_source_document_id
,l_source_document_line_id
FROM oe_order_lines_all
WHERE line_id = l_line_id;