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_LRF_GENERATE_PVT dependencies on OKL_INDEX_VALUES

Line 200: ,okl_index_values c

196: ,lrs_eff_from IN date) IS
197: SELECT (c.value+nvl(b.spread,0)) value
198: FROM okl_fe_std_rt_tmp_v a
199: ,okl_fe_std_rt_tmp_vers b
200: ,okl_index_values c
201: WHERE a.std_rate_tmpl_id = b.std_rate_tmpl_id AND a.index_id = c.idx_id
202: AND b.std_rate_tmpl_ver_id = csr_std_rate_tmpl_ver_id
203: AND lrs_eff_from BETWEEN c.datetime_valid AND nvl(c.datetime_invalid, lrs_eff_from + 1);
204:

Line 373: --if srt is of index rate type take rate from okl_index_values for lrs version effective from

369: /*OPEN get_srt_type_rate(c_rate_set_rec.std_rate_tmpl_ver_id);
370: FETCH get_srt_type_rate INTO l_srt_type
371: ,l_rate ;
372: CLOSE get_srt_type_rate;
373: --if srt is of index rate type take rate from okl_index_values for lrs version effective from
374: IF l_srt_type = 'INDEX' THEN
375: OPEN get_srt_index_rate(c_rate_set_rec.std_rate_tmpl_ver_id
376: ,c_rate_set_rec.effective_from_date);
377: FETCH get_srt_index_rate INTO l_rate ;