The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT hz.party_name
INTO l_return_value
FROM hz_parties hz,
fun_trx_batches btch,
fun_trx_headers head
WHERE hz.party_id = btch.initiator_id
AND btch.batch_id = head.batch_id
AND head.trx_id = p_transaction_id;
SELECT DISTINCT xla.name
INTO l_return_value
FROM xle_firstparty_information_v xla,
fun_trx_batches btch,
fun_trx_headers head
WHERE xla.legal_entity_id = btch.from_le_id
AND btch.batch_id = head.batch_id
AND head.trx_id = p_transaction_id;
SELECT DISTINCT gl.name
INTO l_return_value
FROM gl_ledgers gl,
fun_trx_batches btch,
fun_trx_headers head
WHERE gl.ledger_id = btch.from_ledger_id
AND btch.batch_id = head.batch_id
AND head.trx_id = p_transaction_id;
SELECT DISTINCT tt.trx_type_name
INTO l_return_value
FROM fun_trx_types_tl tt,
fun_trx_batches btch,
fun_trx_headers head
WHERE tt.trx_type_id = btch.trx_type_id
AND btch.batch_id = head.batch_id
AND head.trx_id = p_transaction_id;
SELECT DISTINCT hz.party_name
INTO l_return_value
FROM hz_parties hz,
fun_trx_headers head
WHERE hz.party_id = head.initiator_id
AND head.trx_id = p_transaction_id;
SELECT DISTINCT hz.party_name
INTO l_return_value
FROM hz_parties hz,
fun_trx_headers head
WHERE hz.party_id = head.recipient_id
AND head.trx_id = p_transaction_id;
SELECT DISTINCT xla.name
INTO l_return_value
FROM xle_firstparty_information_v xla,
fun_trx_headers head
WHERE xla.legal_entity_id = head.to_le_id
AND head.trx_id = p_transaction_id;
SELECT DISTINCT gl.name
INTO l_return_value
FROM gl_ledgers gl,
fun_trx_headers head
WHERE gl.ledger_id = head.to_ledger_id
AND head.trx_id = p_transaction_id;
SELECT DISTINCT hz.party_name
INTO l_return_value
FROM hz_parties hz,
fun_dist_lines dist
WHERE hz.party_id = dist.party_id
AND dist.dist_id = p_dist_id;
SELECT chart_of_accounts_id
INTO l_chart_of_accounts_id
FROM gl_ledgers gl,
fun_trx_headers head
WHERE gl.ledger_id = head.to_ledger_id
AND head.trx_id = p_transaction_id;