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_SEEDED_FUNCTIONS_PVT dependencies on OKL_INDICES

Line 3156: -- OKL_INDICES idx

3152: -- CURSOR interest_rate_csr(p_ctr_id NUMBER, p_accrual_date DATE) IS
3153: -- SELECT idv.value
3154: -- FROM OKC_RULES_B rule,
3155: -- OKL_INDEX_VALUES idv,
3156: -- OKL_INDICES idx
3157: -- WHERE rule.rule_information_category = 'LAIVAR'
3158: -- AND rule.dnz_chr_id = p_ctr_id
3159: -- AND TO_NUMBER(rule.rule_information2) = idx.id
3160: -- AND idx.ID = idv.idx_id

Line 3163: -- OKL_INDICES idx,

3159: -- AND TO_NUMBER(rule.rule_information2) = idx.id
3160: -- AND idx.ID = idv.idx_id
3161: -- AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
3162: -- FROM OKL_INDEX_VALUES idv ,
3163: -- OKL_INDICES idx,
3164: -- OKC_RULES_B rules
3165: -- WHERE rules.rule_information_category = 'LAIVAR'
3166: -- AND rules.dnz_chr_id = p_ctr_id
3167: -- AND rules.rule_information2 = idx.id

Line 3176: OKL_INDICES idx

3172: CURSOR interest_rate_csr(p_ctr_id NUMBER, p_accrual_date DATE) IS
3173: SELECT idv.value
3174: FROM OKL_K_RATE_PARAMS okl,
3175: OKL_INDEX_VALUES idv,
3176: OKL_INDICES idx
3177: WHERE okl.khr_id = p_ctr_id
3178: AND okl.parameter_type_code = 'ACTUAL'
3179: AND okl.effective_to_date IS NULL
3180: AND okl.interest_index_id = idx.id

Line 3184: OKL_INDICES idx,

3180: AND okl.interest_index_id = idx.id
3181: AND idx.ID = idv.idx_id
3182: AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
3183: FROM OKL_INDEX_VALUES idv ,
3184: OKL_INDICES idx,
3185: OKL_K_RATE_PARAMS rate
3186: WHERE rate.khr_id = p_ctr_id
3187: AND rate.parameter_type_code = 'ACTUAL'
3188: AND rate.effective_to_date IS NULL