25: union all
26: select count(*) cnt
27: from
28: HZ_LOCATIONS hzl,
29: HZ_PARTIES hzp,
30: HZ_PARTY_SITES hzps
31: WHERE hzps.location_id = hzl.location_id
32: AND hzps.party_id = hzp.party_id
33: AND greatest(hzl.last_update_date, hzp.last_update_date,