238: padv.postal_code padv_postal_code,
239: fnd.TERRITORY_SHORT_NAME padv_country_desc
240: FROM
241: hz_parties padv,
242: hz_party_sites hps,
243: hz_party_site_uses hpsu,
244: fnd_territories_vl fnd
245: WHERE padv.party_id = cp_person_id AND
246: padv.party_type = 'PERSON' AND