5268: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5269: ) IS
5270: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5271: SELECT party_site_id
5272: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5273: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5274: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5275: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5276:
5269: ) IS
5270: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5271: SELECT party_site_id
5272: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5273: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5274: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5275: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5276:
5277: I NUMBER;
5271: SELECT party_site_id
5272: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5273: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5274: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5275: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5276:
5277: I NUMBER;
5278: J NUMBER:=1;
5279: l_party_site_id NUMBER;