DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on AP_INVOICE_PAYMENT_HISTORY_V

Line 889: , ap_invoice_payment_history_v iph

885: select iph.check_date borrower_payment_date
886: , sum(iph.amount) borrower_payment
887: from ap_invoices_all ap_inv
888: , okl_trx_ap_invoices_v okl_inv
889: , ap_invoice_payment_history_v iph
890: , okl_txl_ap_inv_lns_all_b okl_inv_ln
891: , okl_cnsld_Ap_invs_all okl_cnsld
892: , fnd_application fnd_app
893: where okl_inv.id = okl_inv_ln.tap_id

Line 915: , ap_invoice_payment_history_v iph

911: Cursor c_payment_amount_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE) IS
912: select sum(iph.amount) payment_amount
913: from ap_invoices_all ap_inv
914: , okl_trx_ap_invoices_v okl_inv
915: , ap_invoice_payment_history_v iph
916: , okl_txl_ap_inv_lns_all_b okl_inv_ln
917: , okl_cnsld_Ap_invs_all okl_cnsld
918: , fnd_application fnd_app
919: where okl_inv.id = okl_inv_ln.tap_id