APPS.CS_ERES_INT_PKG dependencies on HZ_PARTY_SITES

Line 1442: hz_party_sites hzp

1438: nvl2(loc.province,', '||loc.province, NULL) ||
1439: nvl2(loc.postal_code, ' '||loc.postal_code,NULL) ||
1440: nvl2(loc.country, ' ' || loc.country, NULL)
1441: FROM HZ_LOCATIONS LOC,
1442: hz_party_sites hzp
1443: WHERE hzp.party_site_id = v_incident_location_id
1444: AND hzp.location_id = loc.location_id;
1445:
1446: l_Incident_Address VARCHAR2(2000);