APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_TXL_AP_INV_LNS_B

Line 495: okl_txl_ap_inv_lns_b b

491: CURSOR c_tot_amt_disbursed (p_ia_id NUMBER, p_vendor_site_id NUMBER, p_fee_line_id NUMBER)
492: IS
493: SELECT NVL(SUM(b.amount),0)
494: FROM okl_trx_ap_invoices_b a,
495: okl_txl_ap_inv_lns_b b
496: WHERE a.id = b.tap_id
497: AND a.trx_status_code in ('ENTERED', 'APPROVED', 'PROCESSED')
498: AND b.amount > 0
499: AND b.khr_id = p_ia_id