DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_INDICES

Line 3056: FROM okl_indices idx,

3052: CURSOR c_int_rate(cp_index_id NUMBER, cp_start_date DATE, cp_end_date DATE) IS
3053: SELECT ive.value VALUE,
3054: GREATEST(trunc(cp_start_date),datetime_valid) VALID_FROM,
3055: LEAST(trunc(cp_end_date),NVL(datetime_invalid, GREATEST(trunc(sysdate),trunc(cp_end_date)))) VALID_UNTIL
3056: FROM okl_indices idx,
3057: okl_index_values ive
3058: WHERE idx.id = cp_index_id
3059: AND idx.id = ive.idx_id
3060: AND (cp_start_date BETWEEN ive.datetime_valid AND nvl(ive.datetime_invalid, trunc(cp_start_date))