APPS.OKL_LEASE_RATE_FACTORS_PVT dependencies on OKL_FE_STD_RT_TMP_V

Line 848: FROM okl_fe_std_rt_tmp_v a

844: SELECT a.rate_type_code
845: ,(b.srt_rate+nvl(b.spread,0)) srt_rate
846: ,min_adj_rate
847: ,max_adj_rate
848: FROM okl_fe_std_rt_tmp_v a
849: ,okl_fe_std_rt_tmp_vers b
850: WHERE a.std_rate_tmpl_id = b.std_rate_tmpl_id
851: AND b.std_rate_tmpl_ver_id = csr_std_rate_tmpl_ver_id;
852:

Line 849: ,okl_fe_std_rt_tmp_vers b

845: ,(b.srt_rate+nvl(b.spread,0)) srt_rate
846: ,min_adj_rate
847: ,max_adj_rate
848: FROM okl_fe_std_rt_tmp_v a
849: ,okl_fe_std_rt_tmp_vers b
850: WHERE a.std_rate_tmpl_id = b.std_rate_tmpl_id
851: AND b.std_rate_tmpl_ver_id = csr_std_rate_tmpl_ver_id;
852:
853: CURSOR get_srt_index_rate(csr_std_rate_tmpl_ver_id IN number

Line 856: FROM okl_fe_std_rt_tmp_v a

852:
853: CURSOR get_srt_index_rate(csr_std_rate_tmpl_ver_id IN number
854: ,lrs_eff_from IN date) IS
855: SELECT (c.value+nvl(b.spread,0)) value
856: FROM okl_fe_std_rt_tmp_v a
857: ,okl_fe_std_rt_tmp_vers b
858: ,okl_index_values c
859: WHERE a.std_rate_tmpl_id = b.std_rate_tmpl_id AND a.index_id = c.idx_id
860: AND b.std_rate_tmpl_ver_id = csr_std_rate_tmpl_ver_id

Line 857: ,okl_fe_std_rt_tmp_vers b

853: CURSOR get_srt_index_rate(csr_std_rate_tmpl_ver_id IN number
854: ,lrs_eff_from IN date) IS
855: SELECT (c.value+nvl(b.spread,0)) value
856: FROM okl_fe_std_rt_tmp_v a
857: ,okl_fe_std_rt_tmp_vers b
858: ,okl_index_values c
859: WHERE a.std_rate_tmpl_id = b.std_rate_tmpl_id AND a.index_id = c.idx_id
860: AND b.std_rate_tmpl_ver_id = csr_std_rate_tmpl_ver_id
861: AND lrs_eff_from BETWEEN c.datetime_valid AND nvl(c.datetime_invalid, lrs_eff_from + 1);