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 1629: okl_strm_elements_v sel

1625: CURSOR l_laon_payment_csr(cp_khr_id IN NUMBER) IS
1626: SELECT NVL(SUM(sel.amount), 0) loan_excess_amount
1627: FROM okl_streams_v stm,
1628: okl_strm_type_v sty,
1629: okl_strm_elements_v sel
1630: WHERE stm.khr_id = cp_khr_id
1631: AND stm.id = sel.stm_id
1632: AND stm.sty_id = sty.id
1633: AND sty.stream_type_purpose = 'EXCESS_LOAN_PAYMENT_PAID';

Line 1814: okl_strm_elements_v sel

1810: CURSOR l_stream_csr(cp_khr_id IN NUMBER, cp_term_date IN DATE) IS
1811: SELECT max(sel.stream_element_date)
1812: FROM okl_streams_v stm,
1813: okl_strm_type_v sty,
1814: okl_strm_elements_v sel
1815: WHERE stm.khr_id = cp_khr_id
1816: AND stm.id = sel.stm_id
1817: AND stm.sty_id = sty.id
1818: AND sty.stream_type_purpose = 'RENT'