5381: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5382: ) IS
5383: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5384: SELECT party_site_id
5385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5386: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5388:
5389: I NUMBER;
5383: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5384: SELECT party_site_id
5385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5386: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5388:
5389: I NUMBER;
5390: J NUMBER:=1;
5391: l_party_site_id NUMBER;