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 1330: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

1326: from ap_invoices_all ap_inv,
1327: okl_trx_ap_invoices_b okl_inv,
1328: ap_payment_schedules_all pay_sche
1329: ,okl_cnsld_ap_invs_all cnsld
1330: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
1331: ,fnd_application fnd_app
1332: where okl_inv.id = okl_inv_ln.tap_id
1333: and okl_inv_ln.khr_id = p_chr_id
1334: and ap_inv.application_id = fnd_app.application_id

Line 3896: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

3892: FROM ap_invoices_all ap_inv,
3893: okl_trx_ap_invoices_b okl_inv,
3894: ap_invoice_payment_history_v iph
3895: ,okl_cnsld_ap_invs_all cnsld
3896: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
3897: ,fnd_application fnd_app
3898: WHERE okl_inv.id = okl_inv_ln.tap_id
3899: AND okl_inv_ln.khr_id = p_contract_id
3900: AND ap_inv.application_id = fnd_app.application_id

Line 3936: -- sjalasut, modified the cursor to have khr_id referred from okl_txl_ap_inv_lns_all_b

3932: AND sty.stream_type_purpose = decode(p_rev_rec_method, 'ACTUAL', 'UNSCHEDULED_LOAN_PAYMENT','UNSCHEDULED_PRINCIPAL_PAYMENT')
3933: GROUP BY raa.apply_date
3934: ORDER BY txn_date asc;
3935:
3936: -- sjalasut, modified the cursor to have khr_id referred from okl_txl_ap_inv_lns_all_b
3937: Cursor pymt_rcpt_dtls_daily_int_csr (p_contract_id NUMBER,
3938: p_start_date DATE,
3939: p_due_date DATE ) IS
3940: SELECT iph.check_date txn_date,

Line 3947: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

3943: FROM ap_invoices_all ap_inv,
3944: okl_trx_ap_invoices_v okl_inv,
3945: ap_invoice_payment_history_v iph
3946: ,okl_cnsld_ap_invs_all cnsld
3947: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
3948: ,fnd_application fnd_app
3949: WHERE okl_inv.id = okl_inv_ln.tap_id
3950: AND okl_inv_ln.khr_id = p_contract_id
3951: AND ap_inv.application_id = fnd_app.application_id

Line 4821: -- okl_txl_ap_inv_lns_all_b

4817: AND khr.id = p_contract_id;
4818: */
4819:
4820: -- sjalasut, modified the cursor to have khr_id referred from
4821: -- okl_txl_ap_inv_lns_all_b
4822: Cursor pymt_rcpt_actual_var_int_csr (p_contract_id NUMBER,
4823: p_due_date DATE) IS
4824: SELECT iph.check_date txn_date,
4825: sum(iph.amount) txn_amount,

Line 4831: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

4827: FROM ap_invoices_all ap_inv,
4828: okl_trx_ap_invoices_v okl_inv,
4829: ap_invoice_payment_history_v iph
4830: ,okl_cnsld_ap_invs_all cnsld
4831: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
4832: ,fnd_application fnd_app
4833: WHERE okl_inv.id = okl_inv_ln.tap_id
4834: AND okl_inv_ln.khr_id = p_contract_id
4835: AND ap_inv.application_id = fnd_app.application_id

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

4857: AND sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
4858: GROUP BY sel.stream_element_date
4859: ORDER BY txn_date asc, txn_type;
4860:
4861: -- sjalasut, modified the cursor to have khr_id referred from okl_txl_Ap_inv_lns_all_b
4862: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
4863: Cursor pymt_rcpt_est_bill_var_int_csr (p_contract_id NUMBER,
4864: p_due_date DATE) IS
4865: SELECT iph.check_date txn_date,

Line 4872: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

4868: FROM ap_invoices_all ap_inv,
4869: okl_trx_ap_invoices_v okl_inv,
4870: ap_invoice_payment_history_v iph
4871: ,okl_cnsld_ap_invs_all cnsld
4872: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
4873: ,fnd_application fnd_app
4874: WHERE okl_inv.id = okl_inv_ln.tap_id
4875: AND okl_inv_ln.khr_id = p_contract_id
4876: AND ap_inv.application_id = fnd_app.application_id

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

7871: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
7872:
7873: --checks if newly created Borrower Payment exist
7874: --prior to date passed
7875: -- sjalasut, modified the cursor to have khr_id be passed from okl_txl_ap_inv_lns_all_b
7876: CURSOR l_borrow_payment_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
7877: SELECT 'Y' return_value
7878: FROM ap_invoices_all ap_inv,
7879: okl_trx_ap_invoices_v okl_inv,

Line 7882: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

7878: FROM ap_invoices_all ap_inv,
7879: okl_trx_ap_invoices_v okl_inv,
7880: ap_invoice_payment_history_v iph
7881: ,okl_cnsld_ap_invs_all cnsld
7882: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
7883: ,fnd_application fnd_app
7884: WHERE okl_inv.id = okl_inv_ln.tap_id
7885: AND okl_inv_ln.khr_id = cp_khr_id
7886: AND ap_inv.application_id = fnd_app.application_id

Line 8175: ,okl_txl_ap_inv_lns_all_b okl_inv_ln

8171: FROM ap_invoices_all ap_inv,
8172: okl_trx_ap_invoices_v okl_inv,
8173: ap_invoice_payment_history_v iph
8174: ,okl_cnsld_ap_invs_all cnsld
8175: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
8176: ,fnd_application fnd_app
8177: WHERE okl_inv.id = okl_inv_ln.tap_id
8178: AND okl_inv_ln.khr_id = cp_khr_id
8179: AND ap_inv.application_id = fnd_app.application_id