The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT amount_applied,
amount_applied_from INTO l_amount_applied,l_amount_applied_from
FROM ar_receivable_applications
WHERE receivable_application_id = p_receivable_application_id;
SELECT count(*)
INTO l_valid
FROM AR_RECEIVABLE_APPLICATIONS ra
WHERE ra.receivable_application_id = p_receivable_application_id
and ra.display = 'Y'
and ra.status = p_application_type
and ra.application_type = 'CM';
select type
from ar_receivables_trx rt
where receivables_trx_id = p_receivables_trx_id;
SELECT sum(amount_applied)
INTO l_existing_cmref_amount
FROM ar_receivable_applications
WHERE applied_payment_schedule_id = -8
AND status = 'ACTIVITY'
AND NVL(confirmed_flag,'Y') = 'Y'
AND customer_trx_id = p_customer_trx_id;
SELECT NVL(amount_from,0),
NVL(amount_to,0)
INTO l_amount_from,
l_amount_to
FROM ar_approval_user_limits
where currency_code = p_currency_code
and user_id = l_user_id
and document_type ='CMREF';
SELECT ct.receipt_method_id,
ct.customer_bank_account_id,
ct.previous_customer_trx_id,
ct.complete_flag,
rc.remit_flag,
rma.remittance_ccid
FROM ra_customer_trx ct,
ar_receipt_methods rm,
ar_receipt_classes rc,
ar_receipt_method_accounts rma
WHERE ct.customer_trx_id = p_customer_trx_id
AND ct.receipt_method_id = rm.receipt_method_id(+)
AND rm.receipt_class_id = rc.receipt_class_id(+)
AND rm.receipt_method_id = rma.receipt_method_id(+)
AND ROWNUM = 1;
SELECT SUM(amount_due_original), SUM(amount_due_remaining)
FROM ar_payment_schedules
WHERE customer_trx_id = p_customer_trx_id;