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_LOSS_PROV_PVT dependencies on OKL_STRM_ELEMENTS

Line 216: OKL_STRM_ELEMENTS ste

212: CURSOR principal_bal_csr(p_ctr_id NUMBER, p_start_date DATE, p_end_date DATE, p_prin_bal_id NUMBER) IS
213: SELECT SUM(ste.amount)
214: FROM OKL_STRM_TYPE_B sty,
215: OKL_STREAMS stm,
216: OKL_STRM_ELEMENTS ste
217: WHERE stm.khr_id = p_ctr_id
218: AND stm.active_yn = 'Y'
219: AND stm.say_code = 'CURR'
220: AND sty.id = p_prin_bal_id

Line 231: OKL_STRM_ELEMENTS ste

227: CURSOR prior_prin_bal_csr(p_ctr_id NUMBER, p_start_date DATE, p_prin_bal_id NUMBER) IS
228: SELECT SUM(ste.amount)
229: FROM OKL_STRM_TYPE_B sty,
230: OKL_STREAMS stm,
231: OKL_STRM_ELEMENTS ste
232: WHERE stm.khr_id = p_ctr_id
233: AND stm.active_yn = 'Y'
234: AND stm.say_code = 'CURR'
235: AND sty.id = p_prin_bal_id

Line 241: OKL_STRM_ELEMENTS ste

237: AND ste.stm_id = stm.id
238: AND ste.stream_element_date = (SELECT MAX(stream_element_date)
239: FROM OKL_STRM_TYPE_B sty,
240: OKL_STREAMS stm,
241: OKL_STRM_ELEMENTS ste
242: WHERE stm.khr_id = p_ctr_id
243: AND stm.active_yn = 'Y'
244: AND stm.say_code = 'CURR'
245: AND sty.id = p_prin_bal_id

Line 1254: OKL_STRM_ELEMENTS ste

1250: CURSOR residual_value_csr (p_khr_id NUMBER, p_sty_id NUMBER) IS
1251: SELECT ste.amount
1252: FROM OKL_STRM_TYPE_B sty,
1253: OKL_STREAMS stm,
1254: OKL_STRM_ELEMENTS ste
1255: WHERE stm.khr_id = p_khr_id
1256: AND stm.sty_id = sty.id
1257: AND sty.id = p_sty_id
1258: AND stm.id = ste.stm_id