DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on OKL_TRX_AP_INVOICES_V

Line 737: , okl_trx_ap_invoices_v okl_inv

733: Cursor c_borrower_payment_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE, cp_to_date IN DATE) IS
734: select iph.check_date borrower_payment_date
735: , sum(iph.amount) borrower_payment
736: from ap_invoices_all ap_inv
737: , okl_trx_ap_invoices_v okl_inv
738: , ap_invoice_payment_history_v iph
739: , okl_txl_ap_inv_lns_all_b okl_inv_ln
740: , okl_cnsld_Ap_invs_all okl_cnsld
741: , fnd_application fnd_app

Line 763: , okl_trx_ap_invoices_v okl_inv

759: -- changes made as part of OKLR12B disbursements project
760: Cursor c_payment_amount_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE) IS
761: select sum(iph.amount) payment_amount
762: from ap_invoices_all ap_inv
763: , okl_trx_ap_invoices_v okl_inv
764: , ap_invoice_payment_history_v iph
765: , okl_txl_ap_inv_lns_all_b okl_inv_ln
766: , okl_cnsld_Ap_invs_all okl_cnsld
767: , fnd_application fnd_app