DBA Data[Home] [Help]

APPS.PAY_NL_ABP_REPORT dependencies on FND_LOOKUP_VALUES

Line 17: FROM fnd_lookup_values

13: CURSOR c_get_lookup_value (c_lookup_type IN VARCHAR2
14: ,c_lookup_code IN VARCHAR2
15: ,c_language IN VARCHAR2) IS
16: SELECT meaning
17: FROM fnd_lookup_values
18: WHERE lookup_type = c_lookup_type
19: AND language = c_language
20: AND lookup_code = c_lookup_code;
21:

Line 44: FROM fnd_lookup_values

40: -------------------------------------------------------------------------------
41: FUNCTION get_IANA_charset RETURN VARCHAR2 IS
42: CURSOR csr_get_iana_charset IS
43: SELECT tag
44: FROM fnd_lookup_values
45: WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
46: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
47: INSTR(USERENV('LANGUAGE'), '.') + 1)
48: AND language = 'US';

Line 50: lv_iana_charset fnd_lookup_values.tag%type;

46: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
47: INSTR(USERENV('LANGUAGE'), '.') + 1)
48: AND language = 'US';
49:
50: lv_iana_charset fnd_lookup_values.tag%type;
51: BEGIN
52: OPEN csr_get_iana_charset;
53: FETCH csr_get_iana_charset INTO lv_iana_charset;
54: CLOSE csr_get_iana_charset;