APPS.OKL_LTE_INT_PVT dependencies on OKL_INDEX_VALUES

Line 67: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;

63: -- Variables for Late Interest rules Call
64: l_late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE;
65: l_late_int_rate OKL_LATE_POLICIES_V.LATE_INT_RATE%TYPE;
66: l_adder_rate OKL_LATE_POLICIES_V.ADDER_RATE%TYPE;
67: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;
68: l_days_in_year OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE;
69: l_days_calc NUMBER := 0;
70: l_held_until_date DATE;
71:

Line 231: , OKL_INDEX_VALUES IDX

227: , NVL(LTE.MAXIMUM_LATE_INTEREST,9999999999) MAXIMUM_LATE_INTEREST
228: , NVL(IDX.value,0) INDEX_RATE
229: , NVL(LTE.DAYS_IN_YEAR, 'ACTUAL') DAYS_IN_YEAR
230: FROM OKL_LATE_POLICIES_V LTE
231: , OKL_INDEX_VALUES IDX
232: WHERE LTE.NAME = cp_name
233: AND LTE.idx_id = IDX.idx_id(+)
234: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(IDX.DATETIME_VALID, SYSDATE)) AND TRUNC(NVL(IDX.DATETIME_INVALID, SYSDATE));
235: