APPS.CS_ERES_INT_PKG dependencies on HZ_LOCATIONS

Line 1429: FROM HZ_LOCATIONS LOC

1425: nvl2(loc.state, ', ' ||loc.state, NULL) ||
1426: nvl2(loc.province,', '||loc.province, NULL)||
1427: nvl2(loc.postal_code, ' '||loc.postal_code,NULL) ||
1428: nvl2(loc.country, ' ' || loc.country, NULL )
1429: FROM HZ_LOCATIONS LOC
1430: WHERE loc.location_id = v_incident_location_id;
1431:
1432: CURSOR Get_SR_PS_Location (v_incident_location_id NUMBER) IS
1433: SELECT loc.address1 || nvl2(loc.address2,','||loc.address2,NULL) ||

Line 1441: FROM HZ_LOCATIONS LOC,

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

Line 1787: IF l_incident_location_type ='HZ_LOCATIONS' THEN

1783:
1784: END IF;
1785:
1786: IF l_incident_location_id IS NOT NULL THEN
1787: IF l_incident_location_type ='HZ_LOCATIONS' THEN
1788: OPEN Get_SR_Location (l_incident_location_id);
1789: FETCH Get_SR_Location INTO l_Incident_Address;
1790: CLOSE Get_SR_Location;
1791: ELSIF l_incident_location_type = 'HZ_PARTY_SITE' THEN