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 3620: -- OKL_INDICES idx

3616: -- CURSOR interest_rate_csr(p_ctr_id NUMBER, p_accrual_date DATE) IS
3617: -- SELECT idv.value
3618: -- FROM OKC_RULES_B rule,
3619: -- OKL_INDEX_VALUES idv,
3620: -- OKL_INDICES idx
3621: -- WHERE rule.rule_information_category = 'LAIVAR'
3622: -- AND rule.dnz_chr_id = p_ctr_id
3623: -- AND TO_NUMBER(rule.rule_information2) = idx.id
3624: -- AND idx.ID = idv.idx_id

Line 3627: -- OKL_INDICES idx,

3623: -- AND TO_NUMBER(rule.rule_information2) = idx.id
3624: -- AND idx.ID = idv.idx_id
3625: -- AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
3626: -- FROM OKL_INDEX_VALUES idv ,
3627: -- OKL_INDICES idx,
3628: -- OKC_RULES_B rules
3629: -- WHERE rules.rule_information_category = 'LAIVAR'
3630: -- AND rules.dnz_chr_id = p_ctr_id
3631: -- AND rules.rule_information2 = idx.id

Line 3640: OKL_INDICES idx

3636: CURSOR interest_rate_csr(p_ctr_id NUMBER, p_accrual_date DATE) IS
3637: SELECT idv.value
3638: FROM OKL_K_RATE_PARAMS okl,
3639: OKL_INDEX_VALUES idv,
3640: OKL_INDICES idx
3641: WHERE okl.khr_id = p_ctr_id
3642: AND okl.parameter_type_code = 'ACTUAL'
3643: AND okl.effective_to_date IS NULL
3644: AND okl.interest_index_id = idx.id

Line 3648: OKL_INDICES idx,

3644: AND okl.interest_index_id = idx.id
3645: AND idx.ID = idv.idx_id
3646: AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
3647: FROM OKL_INDEX_VALUES idv ,
3648: OKL_INDICES idx,
3649: OKL_K_RATE_PARAMS rate
3650: WHERE rate.khr_id = p_ctr_id
3651: AND rate.parameter_type_code = 'ACTUAL'
3652: AND rate.effective_to_date IS NULL