APPS.AHL_UTIL_UC_PKG dependencies on HZ_LOCATIONS

Line 71: FROM hz_party_sites hzsite, hz_locations hzloc

67: decode(hzloc.postal_code, null,null,';'||hzloc.postal_code) ||
68: decode(hzloc.state,null,null,';'||hzloc.state) ||
69: decode(hzloc.province,null,null,';'||hzloc.province) ||
70: hzloc.country Address
71: FROM hz_party_sites hzsite, hz_locations hzloc
72: WHERE hzsite.location_id = hzloc.location_id
73: AND hzsite.party_site_id = p_location_id
74: AND hzsite.status <> 'I';
75:

Line 97: CURSOR hz_locations_csr(p_location_id IN NUMBER) IS

93: decode(country,null,null,';'||country) Location
94: FROM hr_locations_all
95: WHERE location_id = p_location_id;
96:
97: CURSOR hz_locations_csr(p_location_id IN NUMBER) IS
98: SELECT hzloc.address1 ||
99: decode(hzloc.address2,null,null,';'||hzloc.address2) ||
100: decode(hzloc.address3,null,null,';'||hzloc.address3) ||
101: decode(hzloc.address4,null,null,';'||hzloc.address4) ||

Line 107: FROM hz_locations hzloc

103: decode(hzloc.postal_code, null,null,';'||hzloc.postal_code) ||
104: decode(hzloc.state,null,null,';'||hzloc.state) ||
105: decode(hzloc.province,null,null,';'||hzloc.province) ||
106: hzloc.country Address
107: FROM hz_locations hzloc
108: WHERE location_id = p_location_id;
109:
110: -- if location is WIP.
111: CURSOR wip_entity_csr(p_wip_job_id IN NUMBER) IS

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

197: IF (hr_locations_csr%NOTFOUND) THEN
198: l_location := null;
199: END IF;
200: CLOSE hr_locations_csr;
201: ELSIF (p_location_type_code = 'HZ_LOCATIONS') THEN
202: OPEN hz_locations_csr(p_location_id);
203: FETCH hz_locations_csr INTO l_location;
204: IF (hz_locations_csr%NOTFOUND) THEN
205: l_location := null;

Line 202: OPEN hz_locations_csr(p_location_id);

198: l_location := null;
199: END IF;
200: CLOSE hr_locations_csr;
201: ELSIF (p_location_type_code = 'HZ_LOCATIONS') THEN
202: OPEN hz_locations_csr(p_location_id);
203: FETCH hz_locations_csr INTO l_location;
204: IF (hz_locations_csr%NOTFOUND) THEN
205: l_location := null;
206: END IF;

Line 203: FETCH hz_locations_csr INTO l_location;

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

Line 204: IF (hz_locations_csr%NOTFOUND) THEN

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

Line 207: CLOSE hz_locations_csr;

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