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_INT_UTIL_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 1676: okl_strm_elements_v sel

1672: CURSOR l_laon_payment_csr(cp_khr_id IN NUMBER) IS
1673: SELECT NVL(SUM(sel.amount), 0) loan_excess_amount
1674: FROM okl_streams_v stm,
1675: okl_strm_type_v sty,
1676: okl_strm_elements_v sel
1677: WHERE stm.khr_id = cp_khr_id
1678: AND stm.id = sel.stm_id
1679: AND stm.sty_id = sty.id
1680: AND sty.stream_type_purpose = 'EXCESS_LOAN_PAYMENT_PAID';

Line 1861: okl_strm_elements_v sel

1857: CURSOR l_stream_csr(cp_khr_id IN NUMBER, cp_term_date IN DATE) IS
1858: SELECT max(sel.stream_element_date)
1859: FROM okl_streams_v stm,
1860: okl_strm_type_v sty,
1861: okl_strm_elements_v sel
1862: WHERE stm.khr_id = cp_khr_id
1863: AND stm.id = sel.stm_id
1864: AND stm.sty_id = sty.id
1865: AND sty.stream_type_purpose = 'RENT'