The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT nvl(requisition_line_id,0)
INTO l_req_line_id
FROM rcv_transactions
WHERE inv_transaction_id = x_transaction_id
AND transaction_type = 'RECEIVE'
AND organization_id = x_org_id;
SELECT code_combination_id
INTO l_ccid
FROM po_req_distributions_all
WHERE requisition_line_id = l_req_line_id;
/* Update reference_account field in mtl_transaction_accounts */
IF l_req_line_id <> 0 THEN
UPDATE mtl_transaction_accounts
SET reference_account = l_ccid
WHERE transaction_id = x_transaction_id
AND accounting_line_type = 2 ;