DBA Data[Home] [Help]

APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on OKL_BPD_TLD_AR_LINES_V

Line 659: FROM okl_bpd_tld_ar_lines_v ocas

655:
656: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
657: p_grace_days IN NUMBER) IS
658: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
659: FROM okl_bpd_tld_ar_lines_v ocas
660: ,ar_payment_schedules_all aps
661: WHERE ocas.khr_id = p_contract_id
662: AND ocas.customer_trx_id = aps.customer_trx_id
663: AND aps.class IN ('INV','CM')