APPS.OKL_INTEREST_CALC_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 384: FROM OKL_TRX_AP_INVOICES_B oklinv,

380: v_start_date DATE,
381: v_end_date DATE,
382: v_name OKL_INDICES.NAME%TYPE) IS
383: SELECT ac.check_date change_date
384: FROM OKL_TRX_AP_INVOICES_B oklinv,
385: okl_txl_ap_inv_lns_all_b tpl,
386: okl_cnsld_ap_invs_all okl_cnsld,
387: AP_INVOICES inv,
388: AP_INVOICE_PAYMENTS pay,

Line 423: FROM OKL_TRX_AP_INVOICES_B oklinv,

419: -- okl consolidation table okl_cnsld_ap_invs_all to join the consolidated invoices
420: -- from the transaction lines table.
421: CURSOR princ_csr(v_date IN DATE, v_khr_id IN NUMBER) IS
422: SELECT SUM(pay.amount)
423: FROM OKL_TRX_AP_INVOICES_B oklinv,
424: okl_txl_ap_inv_lns_all_b okl_inv_ln,
425: okl_cnsld_ap_invs_all okl_cnsld,
426: AP_INVOICES inv,
427: AP_INVOICE_PAYMENTS pay,

Line 748: FROM OKL_TRX_AP_INVOICES_B oklinv,

744: -- okl consolidation table okl_cnsld_ap_invs_all to join the consolidated invoices
745: -- from the transaction lines table.
746: CURSOR fund_csr(v_khr_id NUMBER) IS
747: SELECT MIN(ac.check_date)
748: FROM OKL_TRX_AP_INVOICES_B oklinv,
749: okl_txl_ap_inv_lns_all_b okl_inv_ln,
750: okl_cnsld_ap_invs_all okl_cnsld,
751: AP_INVOICES inv,
752: AP_INVOICE_PAYMENTS pay,

Line 1010: FROM OKL_TRX_AP_INVOICES_B oklinv,

1006: -- Changed the select statement by Santonyr on 04-Aug-2004 to improve the performance
1007:
1008: CURSOR fund_csr(v_khr_id NUMBER) IS
1009: SELECT MIN(ac.check_date)
1010: FROM OKL_TRX_AP_INVOICES_B oklinv,
1011: okl_txl_ap_inv_lns_all_b okl_inv_ln,
1012: okl_cnsld_ap_invs_all okl_cnsld,
1013: AP_INVOICES inv,
1014: AP_INVOICE_PAYMENTS pay,