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_VAR_INT_CATCHUP_PVT dependencies on OKL_STREAMS

Line 344: ,okl_streams str

340: CURSOR interest_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_stream_type_purpose VARCHAR2, cp_kle_id NUMBER) IS
341: SELECT nvl(SUM(nvl(amount, 0)),0) pmt_amt
342: FROM
343: okl_strm_elements sel
344: ,okl_streams str
345: ,okl_strm_type_b sty
346: WHERE sel.stm_id = str.id
347: AND str.khr_id = cp_khr_id
348: AND str.say_code = 'CURR'

Line 365: okl_streams stm_prin_pmt,

361: -- Bug# 13447258: Support Asset Level calculations
362: CURSOR int_pay_amt_end_date_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_stream_type_purpose VARCHAR2, cp_kle_id NUMBER) IS
363: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
364: FROM okl_strm_type_b sty_prin_pmt,
365: okl_streams stm_prin_pmt,
366: okl_strm_elements sel_prin_pmt
367: WHERE stm_prin_pmt.khr_id = cp_khr_id
368: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
369: AND sel_prin_pmt.stream_element_date >= cp_start_date

Line 379: okl_streams_v stm_prin_pmt,

375:
376: CURSOR principal_adjustment_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_kle_id NUMBER) IS
377: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
378: FROM okl_strm_type_v sty_prin_pmt,
379: okl_streams_v stm_prin_pmt,
380: okl_strm_elements_v sel_prin_pmt
381: WHERE stm_prin_pmt.khr_id = cp_khr_id
382: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
383: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date