APPS.AHL_UTIL_UC_PKG dependencies on HZ_PARTY_SITES

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 160: ELSIF (p_location_type_code = 'HZ_PARTY_SITES' OR p_location_type_code = 'VENDOR_SITE') THEN

156: ELSE
157: l_location := null;
158: END IF;
159: CLOSE get_org_name_csr;
160: ELSIF (p_location_type_code = 'HZ_PARTY_SITES' OR p_location_type_code = 'VENDOR_SITE') THEN
161:
162: -- Bug# 4902980 SQL id: 14398234
163: -- Commenting out Cursor usage ahl_owner_loc_csr and spliting it into
164: -- ahl_owner_loc_prty_csr and ahl_owner_loc_vndr_csr based on p_location_type_code

Line 251: FROM hz_party_sites

247: AND party_type = p_party_type;
248: */
249: CURSOR ahl_owner_loc_prty_csr (p_location_id NUMBER) IS
250: SELECT party_site_number
251: FROM hz_party_sites
252: WHERE party_site_id = p_location_id
253: AND status <> 'I';
254:
255: CURSOR ahl_owner_loc_vndr_csr (p_location_id NUMBER) IS

Line 269: ELSIF (p_location_type_code = 'HZ_PARTY_SITES' OR p_location_type_code = 'VENDOR_SITE') THEN

265: IF (p_location_type_code = 'INVENTORY') THEN
266: --l_location := p_location_type_code;
267: l_location := null;
268:
269: ELSIF (p_location_type_code = 'HZ_PARTY_SITES' OR p_location_type_code = 'VENDOR_SITE') THEN
270: -- Bug# 4902980 SQL id: 14398234
271: -- Commenting out Cursor usage ahl_owner_loc_csr and spliting it into
272: -- ahl_owner_loc_prty_csr and ahl_owner_loc_vndr_csr based on p_location_type_code
273: /*