Line 228: AND (hr_general.chk_geocodes_installed = 'Y' or
224: FROM fnd_descr_flex_contexts_vl
225: WHERE descriptive_flexfield_name = 'Address Location'
226: AND enabled_flag = 'Y'
227: AND descriptive_flex_context_code not in ('Global Data Elements') 228: AND (hr_general.chk_geocodes_installed = 'Y' or 229: descriptive_flex_context_code not in ('CA','US'))
230: AND descriptive_flex_context_name = p_address_style;
231:
232: RETURN l_address_style_code;