eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_TXL_AP_INV_LNS_ALL_B

Line 2260: -- okl_txl_ap_inv_lns_all_b

2256: l_rcpt_tbl_count NUMBER := 0;
2257: l_rcpt_tbl_counter NUMBER := 0;
2258:
2259: -- sjalasut, modified the cursor to have khr_id referred from
2260: -- okl_txl_ap_inv_lns_all_b
2261: Cursor pymt_rcpt_actual_var_int_csr (p_contract_id NUMBER,
2262: p_due_date DATE) IS
2263: SELECT iph.check_date txn_date,
2264: sum(iph.amount) txn_amount,

Line 2270: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

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
2271: ,fnd_application fnd_app
2272: WHERE okl_inv.id = okl_inv_ln.tap_id
2273: AND okl_inv_ln.khr_id = p_contract_id
2274: AND ap_inv.application_id = fnd_app.application_id

Line 2300: -- sjalasut, modified the cursor to have khr_id referred from okl_txl_Ap_inv_lns_all_b

2296: AND sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
2297: GROUP BY sel.stream_element_date
2298: ORDER BY txn_date asc, txn_type;
2299:
2300: -- sjalasut, modified the cursor to have khr_id referred from okl_txl_Ap_inv_lns_all_b
2301: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
2302:
2303: --Bug# 14179413: Include Credit Memos and Adjustments when calculating
2304: -- Actual Principal Balance

Line 2314: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

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
2315: ,fnd_application fnd_app
2316: WHERE okl_inv.id = okl_inv_ln.tap_id
2317: AND okl_inv_ln.khr_id = p_contract_id
2318: AND ap_inv.application_id = fnd_app.application_id

Line 4568: -- sjalasut, modified the cursor to have khr_id be passed from okl_txl_ap_inv_lns_all_b

4564: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
4565:
4566: --checks if newly created Borrower Payment exist
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,

Line 4575: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

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
4576: ,fnd_application fnd_app
4577: WHERE okl_inv.id = okl_inv_ln.tap_id
4578: AND okl_inv_ln.khr_id = cp_khr_id
4579: AND ap_inv.application_id = fnd_app.application_id

Line 4997: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

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
4998: ,fnd_application fnd_app
4999: WHERE okl_inv.id = okl_inv_ln.tap_id
5000: AND okl_inv_ln.khr_id = cp_khr_id
5001: AND ap_inv.application_id = fnd_app.application_id