Line 193: p_derived_locale := hr_general.decode_lookup('CN_PROVINCE',p_town_or_city) || ', ';
189: p_derived_locale OUT NOCOPY VARCHAR2
190: ) is
191: BEGIN
192: if (ltrim(p_town_or_city) is not null) then 193: p_derived_locale := hr_general.decode_lookup('CN_PROVINCE',p_town_or_city) || ', '; 194: end if;
195: if (ltrim(p_region_2) is not null) then
196: p_derived_locale := p_derived_locale || p_region_2 || ', ';
197: end if;