eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INTEREST_CALC_PVT dependencies on OKL_INDEX_VALUES

Line 407: FROM OKL_INDEX_VALUES oiv,

403: AND ac.check_date >= v_start_date
404: AND ac.check_date <= v_end_date
405: UNION
406: SELECT oiv.datetime_valid change_date
407: FROM OKL_INDEX_VALUES oiv,
408: OKL_INDICES oi
409: WHERE oiv.idx_id = oi.id
410: AND oi.name = v_name
411: AND oiv.datetime_valid >= v_start_date

Line 449: FROM OKL_INDEX_VALUES idv,

445: -- This cursor will return the rate of interest as on a particular Day.
446: CURSOR int_max_csr(v_name VARCHAR2,
447: v_interest_date DATE) IS
448: SELECT idv.value
449: FROM OKL_INDEX_VALUES idv,
450: OKL_INDICES idx
451: WHERE idx.ID = idv.IDX_ID
452: AND idx.NAME = v_name
453: AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)

Line 454: FROM OKL_INDEX_VALUES idv ,

450: OKL_INDICES idx
451: WHERE idx.ID = idv.IDX_ID
452: AND idx.NAME = v_name
453: AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
454: FROM OKL_INDEX_VALUES idv ,
455: OKL_INDICES idx
456: WHERE idx.id = idv.idx_id
457: AND idx.name = v_name
458: AND idv.datetime_valid <= v_interest_date);