APPS.HR_FLEXFIELD_INFO dependencies on FND_COMMON_LOOKUPS

Line 70: cursor c_ak_region(p_lookup_code in fnd_common_lookups.lookup_code%type) is

66: p_segment_number IN BINARY_INTEGER) return varchar2 is
67: --
68: -- Cursor for AK data
69: --
70: cursor c_ak_region(p_lookup_code in fnd_common_lookups.lookup_code%type) is
71: select meaning
72: from fnd_common_lookups
73: where upper(lookup_code) = upper(p_lookup_code)
74: and lookup_type = 'AK_WEB_REGION_CODES'

Line 72: from fnd_common_lookups

68: -- Cursor for AK data
69: --
70: cursor c_ak_region(p_lookup_code in fnd_common_lookups.lookup_code%type) is
71: select meaning
72: from fnd_common_lookups
73: where upper(lookup_code) = upper(p_lookup_code)
74: and lookup_type = 'AK_WEB_REGION_CODES'
75: and application_id = 800
76: and enabled_flag = 'Y';

Line 81: l_lookup_code fnd_common_lookups.lookup_code%TYPE;

77:
78: --
79: -- Local Variables
80: --
81: l_lookup_code fnd_common_lookups.lookup_code%TYPE;
82: l_ak_web_region_code fnd_common_lookups.meaning%TYPE;
83: l_proc varchar2(72);
84: --
85: begin

Line 82: l_ak_web_region_code fnd_common_lookups.meaning%TYPE;

78: --
79: -- Local Variables
80: --
81: l_lookup_code fnd_common_lookups.lookup_code%TYPE;
82: l_ak_web_region_code fnd_common_lookups.meaning%TYPE;
83: l_proc varchar2(72);
84: --
85: begin
86: --

Line 2025: l_lookup_code fnd_common_lookups.lookup_code%type;

2021: ,p_flexfield in varchar2
2022: ,p_context_or_id_flex_num in varchar2
2023: ,p_segment in varchar2
2024: ) return varchar2 is
2025: l_lookup_code fnd_common_lookups.lookup_code%type;
2026: begin
2027: if p_flex_type <> 'KEY' then
2028: return substr(p_flexfield, 1, 5) ||
2029: substr(p_context_or_id_flex_num, 1, 4) ||