APPS.CS_ERES_INT_PKG dependencies on HZ_LOCATIONS

Line 1358: FROM HZ_LOCATIONS LOC

1354: nvl2(loc.state, ', ' ||loc.state, NULL) ||
1355: nvl2(loc.province,', '||loc.province, NULL)||
1356: nvl2(loc.postal_code, ' '||loc.postal_code,NULL) ||
1357: nvl2(loc.country, ' ' || loc.country, NULL )
1358: FROM HZ_LOCATIONS LOC
1359: WHERE loc.location_id = v_incident_location_id;
1360:
1361: CURSOR Get_SR_PS_Location (v_incident_location_id NUMBER) IS
1362: SELECT loc.address1 || nvl2(loc.address2,','||loc.address2,NULL) ||

Line 1370: FROM HZ_LOCATIONS LOC,

1366: nvl2(loc.state, ', ' ||loc.state, NULL) ||
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:

Line 1702: IF l_incident_location_type ='HZ_LOCATIONS' THEN

1698:
1699: END IF;
1700:
1701: IF l_incident_location_id IS NOT NULL THEN
1702: IF l_incident_location_type ='HZ_LOCATIONS' THEN
1703: OPEN Get_SR_Location (l_incident_location_id);
1704: FETCH Get_SR_Location INTO l_Incident_Address;
1705: CLOSE Get_SR_Location;
1706: ELSIF l_incident_location_type = 'HZ_PARTY_SITE' THEN