3379: substr(addr.region_1 ,1,20),
3380: substr(addr.region_2 ,1,5),
3381: substr(addr.postal_code ,1,10)
3382: from per_addresses addr,
3383: per_all_people_f ppf
3384: where addr.person_id = ppf.person_id
3385: and ppf.person_id in
3386: (select distinct person_id
3387: from per_assignments_f paf,