APPS.OKL_CSBRW_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

SELECT
NVL(SUM (ARA.amount_applied),0)
FROM
ar_receivable_applications_all ARA,
ar_cash_receipts_all ACR
WHERE
ARA.status IN ( 'ACC' , 'UNAPP') AND
ARA.cash_receipt_id = ACR.cash_receipt_id AND
ACR.pay_from_customer = p_cust_account_id AND
ACR.status IN ( 'APP', 'UNAPP')
GROUP BY ACR.pay_from_customer;

Line: 32

SELECT
NVL(SUM (APS.amount_due_remaining),0)
FROM
ar_payment_schedules_all APS,
ra_customer_trx_all RAC
WHERE
APS.class = 'INV' AND
APS.status = 'OP' AND
APS.customer_trx_id = RAC.customer_trx_id AND
RAC.bill_to_customer_id = p_cust_account_id;