APPS.CS_ERES_INT_PKG dependencies on HZ_PARTY_SITES

Line 1371: hz_party_sites hzp

1367: nvl2(loc.province,', '||loc.province, NULL) ||
1368: nvl2(loc.postal_code, ' '||loc.postal_code,NULL) ||
1369: nvl2(loc.country, ' ' || loc.country, NULL)
1370: FROM HZ_LOCATIONS LOC,
1371: hz_party_sites hzp
1372: WHERE hzp.party_site_id = v_incident_location_id
1373: AND hzp.location_id = loc.location_id;
1374:
1375: l_Incident_Address VARCHAR2(2000);