3793: substr(addr.region_1 ,1,20),
3794: substr(addr.region_2 ,1,5),
3795: substr(addr.postal_code ,1,10)
3796: from per_addresses addr,
3797: per_all_people_f ppf
3798: where addr.person_id = ppf.person_id
3799: and ppf.person_id in
3800: (select distinct person_id
3801: from per_assignments_f paf,