APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_TXL_AP_INV_LNS_B

Line 480: okl_txl_ap_inv_lns_b b

476: CURSOR c_tot_amt_disbursed (p_ia_id NUMBER, p_vendor_site_id NUMBER, p_fee_line_id NUMBER)
477: IS
478: SELECT NVL(SUM(b.amount),0)
479: FROM okl_trx_ap_invoices_b a,
480: okl_txl_ap_inv_lns_b b
481: WHERE a.id = b.tap_id
482: AND a.trx_status_code in ('ENTERED', 'APPROVED', 'PROCESSED')
483: AND b.amount > 0
484: AND b.khr_id = p_ia_id