APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_INDICES

Line 1889: from okl_indices idx,

1885: - GREATEST(trunc(p_start_date),datetime_valid)) DAYS
1886: ,idx.name index_name,
1887: GREATEST(trunc(p_start_date),datetime_valid) VALID_FROM,
1888: LEAST(trunc(p_end_date),NVL(datetime_invalid, sysdate)) VALID_UNTIL
1889: from okl_indices idx,
1890: okl_index_values ive
1891: where idx.id = ive.idx_id
1892: AND ive.idx_id = l_interest_rec.index_name
1893: AND (p_start_date between datetime_valid and nvl(datetime_invalid, SYSDATE)

Line 1902: ,okl_indices ind

1898:
1899: CURSOR c_implicit_rate (p_index_name VARCHAR2, p_end_date DATE) IS
1900: SELECT val.value, ind.name index_name
1901: FROM okl_index_values val
1902: ,okl_indices ind
1903: WHERE val.idx_id = p_index_name
1904: AND ind.id = val.idx_id
1905: AND val.datetime_valid = (SELECT MAX(val.datetime_valid)
1906: FROM OKL_INDEX_VALUES val ,

Line 1907: OKL_INDICES ind

1903: WHERE val.idx_id = p_index_name
1904: AND ind.id = val.idx_id
1905: AND val.datetime_valid = (SELECT MAX(val.datetime_valid)
1906: FROM OKL_INDEX_VALUES val ,
1907: OKL_INDICES ind
1908: WHERE ind.id = val.idx_id
1909: AND val.idx_id = p_index_name
1910: AND val.datetime_valid < p_end_date);
1911:

Line 5470: FROM okl_indices idx,

5466: CURSOR c_int_rate(cp_index_id NUMBER, cp_start_date DATE, cp_end_date DATE) IS
5467: SELECT ive.value VALUE,
5468: GREATEST(trunc(cp_start_date),datetime_valid) VALID_FROM,
5469: LEAST(trunc(cp_end_date),NVL(datetime_invalid, trunc(sysdate))) VALID_UNTIL
5470: FROM okl_indices idx,
5471: okl_index_values ive
5472: WHERE idx.id = cp_index_id
5473: AND idx.id = ive.idx_id
5474: AND (cp_start_date BETWEEN ive.datetime_valid AND nvl(ive.datetime_invalid, trunc(cp_start_date))