APPS.OKL_INTEREST_CALC_PVT dependencies on OKL_INDEX_VALUES

Line 559: FROM OKL_INDEX_VALUES oiv,

555: AND ac.check_date >= v_start_date
556: AND ac.check_date <= v_end_date
557: UNION
558: SELECT oiv.datetime_valid change_date
559: FROM OKL_INDEX_VALUES oiv,
560: OKL_INDICES oi
561: WHERE oiv.idx_id = oi.id
562: AND oi.name = v_name
563: AND oiv.datetime_valid >= v_start_date

Line 600: FROM OKL_INDEX_VALUES idv,

596: -- This cursor will return the rate of interest as on a particular Day.
597: CURSOR int_max_csr(v_name VARCHAR2,
598: v_interest_date DATE) IS
599: SELECT idv.value
600: FROM OKL_INDEX_VALUES idv,
601: OKL_INDICES idx
602: WHERE idx.ID = idv.IDX_ID
603: AND idx.NAME = v_name
604: AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)

Line 605: FROM OKL_INDEX_VALUES idv ,

601: OKL_INDICES idx
602: WHERE idx.ID = idv.IDX_ID
603: AND idx.NAME = v_name
604: AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
605: FROM OKL_INDEX_VALUES idv ,
606: OKL_INDICES idx
607: WHERE idx.id = idv.idx_id
608: AND idx.name = v_name
609: AND idv.datetime_valid <= v_interest_date);