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_K_RATE_PARAMS_PVT dependencies on FND_LOOKUPS

Line 3186: CURSOR fnd_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS

3182: WHERE KHR_ID = p_chr_id
3183: AND parameter_type_code IN ('ACTUAL', 'CONVERSION')
3184: ORDER BY effective_from_date, parameter_type_code;
3185:
3186: CURSOR fnd_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
3187: SELECT meaning
3188: FROM FND_LOOKUPS
3189: WHERE lookup_type = 'OKL_VAR_RATE_PARAMS_TYPE'
3190: AND lookup_code = p_lookup_code

Line 3188: FROM FND_LOOKUPS

3184: ORDER BY effective_from_date, parameter_type_code;
3185:
3186: CURSOR fnd_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
3187: SELECT meaning
3188: FROM FND_LOOKUPS
3189: WHERE lookup_type = 'OKL_VAR_RATE_PARAMS_TYPE'
3190: AND lookup_code = p_lookup_code
3191: AND nvl(enabled_flag,'N') = 'Y'
3192: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate);

Line 3193: l_meaning FND_LOOKUPS.MEANING%TYPE;

3189: WHERE lookup_type = 'OKL_VAR_RATE_PARAMS_TYPE'
3190: AND lookup_code = p_lookup_code
3191: AND nvl(enabled_flag,'N') = 'Y'
3192: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate);
3193: l_meaning FND_LOOKUPS.MEANING%TYPE;
3194:
3195: i NUMBER;
3196: l_int_rate_exist BOOLEAN;
3197: l_addl_int_rate_exist BOOLEAN;

Line 3723: CURSOR get_lkp_meaning(cp_lkp_type FND_LOOKUPS.LOOKUP_TYPE%TYPE

3719: AND PQY.NAME = cp_name
3720: AND QVE.VALUE = cp_value;
3721:
3722: -- Get the lookup meanings
3723: CURSOR get_lkp_meaning(cp_lkp_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
3724: , cp_lkp_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
3725: SELECT
3726: FNDLUP.MEANING
3727: FROM

Line 3724: , cp_lkp_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS

3720: AND QVE.VALUE = cp_value;
3721:
3722: -- Get the lookup meanings
3723: CURSOR get_lkp_meaning(cp_lkp_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
3724: , cp_lkp_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
3725: SELECT
3726: FNDLUP.MEANING
3727: FROM
3728: FND_LOOKUPS FNDLUP

Line 3728: FND_LOOKUPS FNDLUP

3724: , cp_lkp_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
3725: SELECT
3726: FNDLUP.MEANING
3727: FROM
3728: FND_LOOKUPS FNDLUP
3729: WHERE
3730: FNDLUP.LOOKUP_TYPE = cp_lkp_type
3731: AND FNDLUP.LOOKUP_CODE = cp_lkp_code
3732: AND SYSDATE BETWEEN