956: l.country,
957: l.postal_code,
958: l.last_update_date
959: FROM hz_party_sites ps,
960: hz_locations l ,
961: igs_pe_hz_pty_sites ihps
962: WHERE ps.location_id = l.location_id
963: AND ps.party_site_id = ihps.party_site_id(+)
964: AND ps.identifying_address_flag = cp_identifying_address_flag
1009: l.country,
1010: l.postal_code,
1011: l.last_update_date
1012: FROM hz_party_sites ps,
1013: hz_locations l,
1014: hz_party_site_uses psu
1015: WHERE ps.location_id = l.location_id
1016: AND ps.party_site_id = psu.party_site_id
1017: AND psu.status = cp_status