APPS.OKL_FE_STD_RATE_TMPL_PVT dependencies on OKL_INDEX_VALUES_V

Line 576: ,okl_index_values val

572: CURSOR rate_csr(p_index_id IN NUMBER
573: ,p_eff_from IN DATE) IS
574: SELECT val.value
575: FROM okl_indices ind
576: ,okl_index_values val
577: WHERE ind.id = val.idx_id AND ind.id = p_index_id
578: AND p_eff_from BETWEEN val.datetime_valid AND NVL(val.datetime_invalid, TO_DATE('01-01-9999', 'dd-mm-yyyy'));
579:
580: CURSOR srt_unique_chk(p_name IN varchar2) IS

Line 1204: FROM okl_index_values_v

1200:
1201: CURSOR cal_rate_csr(index_id IN NUMBER
1202: ,effective_from IN DATE) IS
1203: SELECT value
1204: FROM okl_index_values_v
1205: WHERE idx_id = index_id AND effective_from >= datetime_valid
1206: AND effective_from <= NVL(datetime_invalid, TO_DATE('01-01-9999', 'dd-mm-yyyy'));
1207:
1208: CURSOR index_id_csr(p_srt_id IN NUMBER) IS