DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_BILLING_UTIL_PVT

Line 2608: sum(nvl(okl_billing_util_pvt.invoice_line_amount_remaining(cust_trx.customer_trx_id, cust_trx_lines.customer_trx_line_id), 0)) Amount_Due_remaining

2604: p_CONTRACT_NUMBER VARCHAR2,
2605: p_from_days number,
2606: p_to_days number) IS
2607: SELECT
2608: sum(nvl(okl_billing_util_pvt.invoice_line_amount_remaining(cust_trx.customer_trx_id, cust_trx_lines.customer_trx_line_id), 0)) Amount_Due_remaining
2609: FROM ra_customer_trx_all cust_trx,
2610: ra_customer_trx_lines_all cust_trx_lines,
2611: ar_payment_schedules_all ar
2612: WHERE cust_trx.customer_trx_id = cust_trx_lines.customer_trx_id