APPS.OKL_INTEREST_MAINT_PVT dependencies on OKL_INDEX_VALUES

Line 36: FROM OKL_INDICES_V idx, OKL_INDEX_VALUES_V idxv

32:
33:
34: l_stmt_org := ' SELECT datetime_valid,
35: datetime_invalid
36: FROM OKL_INDICES_V idx, OKL_INDEX_VALUES_V idxv
37: WHERE idx.id = idxv.idx_id
38: AND idx.name = ' || '''' || ':1' || '''' ||
39: ' AND idx.idx_type = ' || '''' || ':2' || '''' ;
40:

Line 177: FROM OKL_INDICES_V idx, OKL_INDEX_VALUES_V idxv

173:
174:
175: l_stmt_org := ' SELECT datetime_valid,
176: datetime_invalid
177: FROM OKL_INDICES_V idx, OKL_INDEX_VALUES_V idxv
178: WHERE idx.id = idxv.idx_id
179: AND idx.id = ' || ':1' ;
180:
181:

Line 304: OKL_INDEX_VALUES ive

300:
301: CURSOR freq_csr(v_idx_id NUMBER) IS
302: SELECT idx_frequency
303: FROM OKL_INDICES idx,
304: OKL_INDEX_VALUES ive
305: WHERE ive.idx_id = idx.id
306: AND idx.ID = v_idx_id;
307:
308:

Line 592: FROM OKL_INDEX_VALUES

588:
589: CURSOR ive_csr(v_idx_id NUMBER) IS
590: SELECT datetime_valid,
591: datetime_invalid
592: FROM OKL_INDEX_VALUES
593: WHERE idx_id = v_idx_id;
594:
595:
596: BEGIN