APPS.OKL_VARIABLE_INTEREST_PVT dependencies on AP_INVOICES_ALL

Line 2266: FROM ap_invoices_all ap_inv,

2262: p_due_date DATE) IS
2263: SELECT iph.check_date txn_date,
2264: sum(iph.amount) txn_amount,
2265: 'P' txn_type
2266: FROM ap_invoices_all ap_inv,
2267: okl_trx_ap_invoices_v okl_inv,
2268: ap_invoice_payment_history_v iph
2269: ,okl_cnsld_ap_invs_all cnsld
2270: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

Line 2310: FROM ap_invoices_all ap_inv,

2306: p_due_date DATE) IS
2307: SELECT iph.check_date txn_date,
2308: sum(iph.amount) txn_amount,
2309: 'P' txn_type
2310: FROM ap_invoices_all ap_inv,
2311: okl_trx_ap_invoices_v okl_inv,
2312: ap_invoice_payment_history_v iph
2313: ,okl_cnsld_ap_invs_all cnsld
2314: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

Line 4571: FROM ap_invoices_all ap_inv,

4567: --prior to date passed
4568: -- sjalasut, modified the cursor to have khr_id be passed from okl_txl_ap_inv_lns_all_b
4569: CURSOR l_borrow_payment_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4570: SELECT 'Y' return_value
4571: FROM ap_invoices_all ap_inv,
4572: okl_trx_ap_invoices_v okl_inv,
4573: ap_invoice_payment_history_v iph
4574: ,okl_cnsld_ap_invs_all cnsld
4575: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

Line 4993: FROM ap_invoices_all ap_inv,

4989: --get the id's of Borrower Payment
4990: CURSOR l_borrow_payment_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
4991: SELECT iph.invoice_payment_id source_id
4992: , 'AP_INVOICE_PAYMENTS_ALL' source_table
4993: FROM ap_invoices_all ap_inv,
4994: okl_trx_ap_invoices_v okl_inv,
4995: ap_invoice_payment_history_v iph
4996: ,okl_cnsld_ap_invs_all cnsld
4997: ,okl_txl_ap_inv_lns_all_b okl_inv_ln