APPS.OKL_LTE_INT_PVT dependencies on OKL_INDEX_VALUES

Line 70: l_index_rate OKL_INDEX_VALUES.VALUE%TYPE;

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

Line 353: , OKL_INDEX_VALUES IDX

349: , NVL(LTE.MAXIMUM_LATE_INTEREST,9999999999) MAXIMUM_LATE_INTEREST
350: , NVL(IDX.value,0) INDEX_RATE
351: , NVL(LTE.DAYS_IN_YEAR, 'ACTUAL') DAYS_IN_YEAR
352: FROM OKL_LATE_POLICIES_V LTE
353: , OKL_INDEX_VALUES IDX
354: WHERE LTE.NAME = cp_name
355: AND LTE.idx_id = IDX.idx_id(+)
356: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(IDX.DATETIME_VALID, SYSDATE)) AND TRUNC(NVL(IDX.DATETIME_INVALID, SYSDATE));
357: