APPS.AHL_UTIL_UC_PKG dependencies on HZ_PARTY_SITES

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

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

Line 246: FROM hz_party_sites

242: AND party_type = p_party_type;
243: */
244: CURSOR ahl_owner_loc_prty_csr (p_location_id NUMBER) IS
245: SELECT party_site_number
246: FROM hz_party_sites
247: WHERE party_site_id = p_location_id
248: AND status <> 'I';
249:
250: CURSOR ahl_owner_loc_vndr_csr (p_location_id NUMBER) IS

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

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