APPS.OKL_LRF_GENERATE_PVT dependencies on OKL_FE_STD_RT_TMP_V

Line 190: FROM okl_fe_std_rt_tmp_v a

186:
187: CURSOR get_srt_type_rate(csr_std_rate_tmpl_ver_id IN number) IS
188: SELECT a.rate_type_code
189: ,(b.srt_rate+nvl(b.spread,0)) srt_rate
190: FROM okl_fe_std_rt_tmp_v a
191: ,okl_fe_std_rt_tmp_vers b
192: WHERE a.std_rate_tmpl_id = b.std_rate_tmpl_id
193: AND b.std_rate_tmpl_ver_id = csr_std_rate_tmpl_ver_id;
194:

Line 191: ,okl_fe_std_rt_tmp_vers b

187: CURSOR get_srt_type_rate(csr_std_rate_tmpl_ver_id IN number) IS
188: SELECT a.rate_type_code
189: ,(b.srt_rate+nvl(b.spread,0)) srt_rate
190: FROM okl_fe_std_rt_tmp_v a
191: ,okl_fe_std_rt_tmp_vers b
192: WHERE a.std_rate_tmpl_id = b.std_rate_tmpl_id
193: AND b.std_rate_tmpl_ver_id = csr_std_rate_tmpl_ver_id;
194:
195: CURSOR get_srt_index_rate(csr_std_rate_tmpl_ver_id IN number

Line 198: FROM okl_fe_std_rt_tmp_v a

194:
195: CURSOR get_srt_index_rate(csr_std_rate_tmpl_ver_id IN number
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

Line 199: ,okl_fe_std_rt_tmp_vers b

195: CURSOR get_srt_index_rate(csr_std_rate_tmpl_ver_id IN number
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);