The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT okl_wf_item_s.nextval
FROM DUAL;
l_parameter_list.DELETE;
l_LAST_UPDATED_BY NUMBER;
SELECT last_updated_by
FROM okl_asset_returns_b
WHERE id = cp_asset_return_id;
FETCH l_assetreturn_csr INTO l_LAST_UPDATED_BY;
IF l_LAST_UPDATED_BY IS NULL THEN
resultout := 'COMPLETE:INVALID';
, p_user_id => l_last_updated_by
, x_name => l_user
, x_description => l_name);
-- get last_updated_by
CURSOR l_assetreturn_csr(cp_asset_return_id IN NUMBER) IS
SELECT last_updated_by
FROM okl_asset_returns_b
WHERE id = cp_asset_return_id;
l_last_updated_by NUMBER;