1213: pad.town_or_city,
1214: SUBSTR(l.meaning,1,27) county,
1215: SUBSTR(pad.postal_code,1,8)
1216: from per_addresses pad,
1217: hr_lookups l
1218: where pad.person_id = ye_asg.person_id
1219: and pad.primary_flag = 'Y'
1220: and l.lookup_type(+) = 'GB_COUNTY'
1221: and l.lookup_code(+) = pad.region_1