APPS.AHL_UTIL_UC_PKG dependencies on HZ_LOCATIONS

Line 76: FROM hz_party_sites hzsite, hz_locations hzloc

72: decode(hzloc.postal_code, null,null,';'||hzloc.postal_code) ||
73: decode(hzloc.state,null,null,';'||hzloc.state) ||
74: decode(hzloc.province,null,null,';'||hzloc.province) ||
75: hzloc.country Address
76: FROM hz_party_sites hzsite, hz_locations hzloc
77: WHERE hzsite.location_id = hzloc.location_id
78: AND hzsite.party_site_id = p_location_id
79: AND hzsite.status <> 'I';
80:

Line 102: CURSOR hz_locations_csr(p_location_id IN NUMBER) IS

98: decode(country,null,null,';'||country) Location
99: FROM hr_locations_all
100: WHERE location_id = p_location_id;
101:
102: CURSOR hz_locations_csr(p_location_id IN NUMBER) IS
103: SELECT hzloc.address1 ||
104: decode(hzloc.address2,null,null,';'||hzloc.address2) ||
105: decode(hzloc.address3,null,null,';'||hzloc.address3) ||
106: decode(hzloc.address4,null,null,';'||hzloc.address4) ||

Line 112: FROM hz_locations hzloc

108: decode(hzloc.postal_code, null,null,';'||hzloc.postal_code) ||
109: decode(hzloc.state,null,null,';'||hzloc.state) ||
110: decode(hzloc.province,null,null,';'||hzloc.province) ||
111: hzloc.country Address
112: FROM hz_locations hzloc
113: WHERE location_id = p_location_id;
114:
115: -- if location is WIP.
116: CURSOR wip_entity_csr(p_wip_job_id IN NUMBER) IS

Line 206: ELSIF (p_location_type_code = 'HZ_LOCATIONS') THEN

202: IF (hr_locations_csr%NOTFOUND) THEN
203: l_location := null;
204: END IF;
205: CLOSE hr_locations_csr;
206: ELSIF (p_location_type_code = 'HZ_LOCATIONS') THEN
207: OPEN hz_locations_csr(p_location_id);
208: FETCH hz_locations_csr INTO l_location;
209: IF (hz_locations_csr%NOTFOUND) THEN
210: l_location := null;

Line 207: OPEN hz_locations_csr(p_location_id);

203: l_location := null;
204: END IF;
205: CLOSE hr_locations_csr;
206: ELSIF (p_location_type_code = 'HZ_LOCATIONS') THEN
207: OPEN hz_locations_csr(p_location_id);
208: FETCH hz_locations_csr INTO l_location;
209: IF (hz_locations_csr%NOTFOUND) THEN
210: l_location := null;
211: END IF;

Line 208: FETCH hz_locations_csr INTO l_location;

204: END IF;
205: CLOSE hr_locations_csr;
206: ELSIF (p_location_type_code = 'HZ_LOCATIONS') THEN
207: OPEN hz_locations_csr(p_location_id);
208: FETCH hz_locations_csr INTO l_location;
209: IF (hz_locations_csr%NOTFOUND) THEN
210: l_location := null;
211: END IF;
212: CLOSE hz_locations_csr;

Line 209: IF (hz_locations_csr%NOTFOUND) THEN

205: CLOSE hr_locations_csr;
206: ELSIF (p_location_type_code = 'HZ_LOCATIONS') THEN
207: OPEN hz_locations_csr(p_location_id);
208: FETCH hz_locations_csr INTO l_location;
209: IF (hz_locations_csr%NOTFOUND) THEN
210: l_location := null;
211: END IF;
212: CLOSE hz_locations_csr;
213: ELSIF (p_location_type_code = 'WIP') THEN

Line 212: CLOSE hz_locations_csr;

208: FETCH hz_locations_csr INTO l_location;
209: IF (hz_locations_csr%NOTFOUND) THEN
210: l_location := null;
211: END IF;
212: CLOSE hz_locations_csr;
213: ELSIF (p_location_type_code = 'WIP') THEN
214: OPEN wip_entity_csr(p_wip_job_id);
215: FETCH wip_entity_csr INTO l_location;
216: IF (wip_entity_csr%NOTFOUND) THEN