[Home] [Help]
333: substr(l.meaning,1,27) county,
334: substr(pad.postal_code,1,8),
335: country
336: FROM per_addresses pad,
337: hr_lookups l
338: WHERE pad.person_id = p_person_id
339: AND pad.primary_flag = 'Y'
340: AND l.lookup_type(+) = 'GB_COUNTY'
341: AND l.lookup_code(+) = pad.region_1