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 3196: CURSOR fnd_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS

3192: WHERE KHR_ID = p_chr_id
3193: AND parameter_type_code IN ('ACTUAL', 'CONVERSION')
3194: ORDER BY effective_from_date, parameter_type_code;
3195:
3196: CURSOR fnd_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
3197: SELECT meaning
3198: FROM FND_LOOKUPS
3199: WHERE lookup_type = 'OKL_VAR_RATE_PARAMS_TYPE'
3200: AND lookup_code = p_lookup_code

Line 3198: FROM FND_LOOKUPS

3194: ORDER BY effective_from_date, parameter_type_code;
3195:
3196: CURSOR fnd_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
3197: SELECT meaning
3198: FROM FND_LOOKUPS
3199: WHERE lookup_type = 'OKL_VAR_RATE_PARAMS_TYPE'
3200: AND lookup_code = p_lookup_code
3201: AND nvl(enabled_flag,'N') = 'Y'
3202: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate);

Line 3203: l_meaning FND_LOOKUPS.MEANING%TYPE;

3199: WHERE lookup_type = 'OKL_VAR_RATE_PARAMS_TYPE'
3200: AND lookup_code = p_lookup_code
3201: AND nvl(enabled_flag,'N') = 'Y'
3202: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate);
3203: l_meaning FND_LOOKUPS.MEANING%TYPE;
3204:
3205: i NUMBER;
3206: l_int_rate_exist BOOLEAN;
3207: l_addl_int_rate_exist BOOLEAN;

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

3729: AND PQY.NAME = cp_name
3730: AND QVE.VALUE = cp_value;
3731:
3732: -- Get the lookup meanings
3733: CURSOR get_lkp_meaning(cp_lkp_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
3734: , cp_lkp_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
3735: SELECT
3736: FNDLUP.MEANING
3737: FROM

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

3730: AND QVE.VALUE = cp_value;
3731:
3732: -- Get the lookup meanings
3733: CURSOR get_lkp_meaning(cp_lkp_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
3734: , cp_lkp_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
3735: SELECT
3736: FNDLUP.MEANING
3737: FROM
3738: FND_LOOKUPS FNDLUP

Line 3738: FND_LOOKUPS FNDLUP

3734: , cp_lkp_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
3735: SELECT
3736: FNDLUP.MEANING
3737: FROM
3738: FND_LOOKUPS FNDLUP
3739: WHERE
3740: FNDLUP.LOOKUP_TYPE = cp_lkp_type
3741: AND FNDLUP.LOOKUP_CODE = cp_lkp_code
3742: AND SYSDATE BETWEEN