572: )
573: IS
574: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
575: l_location_rec hz_location_v2pub.location_rec_type;
576: l_obj_ver hz_locations.object_version_number%TYPE;
577:
578: CURSOR l_cur IS
579: SELECT object_version_number,location_id
580: from hz_locations
576: l_obj_ver hz_locations.object_version_number%TYPE;
577:
578: CURSOR l_cur IS
579: SELECT object_version_number,location_id
580: from hz_locations
581: where location_id =
582: (SELECT location_id
583: FROM hz_party_sites
584: WHERE party_site_id = p_party_site_id