APPS.OKL_LEASE_RATE_FACTORS_PVT dependencies on OKL_INDEX_VALUES

Line 837: If standard rate template is of type INDEX, it takes the rate from OKL_INDEX_VALUES.

833:
834: END is_residual_tolerance_valid;
835: /**
836: This function returns the rate from the standard rate template version,
837: If standard rate template is of type INDEX, it takes the rate from OKL_INDEX_VALUES.
838: **/
839:
840: FUNCTION get_rate_from_srt(p_srt_version_id IN number
841: ,p_lrs_eff_from IN date) RETURN number IS

Line 858: ,okl_index_values c

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);
862: l_rate number;

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

890: ,l_min_adj_rate
891: ,l_max_adj_rate ;
892: CLOSE get_srt_type_rate;
893:
894: --if srt is of index rate type take rate from okl_index_values for lrs version effective from
895:
896: IF l_srt_type = 'INDEX' THEN
897: OPEN get_srt_index_rate(p_srt_version_id, p_lrs_eff_from);
898: FETCH get_srt_index_rate INTO l_rate ;