The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT recommendation_value2
INTO l_credit_limit
FROM ar_cmgt_cf_recommends
WHERE case_folder_id = transactionIdIn
AND credit_recommendation = 'CREDIT_LIMIT';
SELECT recommendation_value2
INTO l_credit_limit
FROM ar_cmgt_cf_recommends
WHERE case_folder_id = transactionIdIn
AND credit_recommendation = 'TXN_CREDIT_LIMIT';
SELECT SUM(SCORE)
INTO l_score
FROM ar_cmgt_cf_dtls
WHERE case_folder_id = transactionIdIn;
SELECT recommendation_value1
INTO l_credit_classification
FROM ar_cmgt_cf_recommends
WHERE case_folder_id = transactionIdIn
AND credit_recommendation = 'CLASSIFICATION';
SELECT limit_currency
INTO l_credit_currency
FROM ar_cmgt_case_folders
WHERE case_folder_id = transactionIdIn;
SELECT exchange_rate_type
INTO l_exchange_rate_type
FROM ar_cmgt_case_folders
WHERE case_folder_id = transactionIdIn;
select nvl(a.limit_amount,a.trx_amount)
into l_amount_requested
from ar_cmgt_credit_requests a,
ar_cmgt_case_folders b
WHERE b.case_folder_id = transactionIdIn
AND a.credit_request_id = b.credit_request_id
AND b.type = 'CASE';