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,
34: hzps.last_update_date)
173:
174: cursor c4 is
175: select avg(nvl(vsize(party_site_id),0)),
176: avg(nvl(vsize(party_site_name),0))
177: from HZ_PARTY_SITES where last_update_date
178: between p_from_date and p_to_date;
179:
180: cursor c5 is
181: select avg(nvl(vsize(DESCRIPTION),0)),