declare 
	v_object_id_two integer;
	v_revision_id integer;
begin
for row in (select party_id from parties where party_id not in (-1, -2, 1136, 21610, 21613, 21737, 21900, 21908, 22012, 22016, 22017, 22040)) loop

	select object_id_two into v_object_id_two from acs_rels where object_id_one = row.party_id and rel_type = 'user_portrait_rel';
	select revision_id into v_revision_id from cr_revisions where item_id = v_object_id_two;
	delete from images where image_id = v_revision_id;
	content_revision.delete(v_revision_id);
	delete from user_bios where user_id = row.party_id;
	delete from user_preferences where user_id = row.party_id;
	delete from users where user_id = row.party_id;
	delete from persons where person_id = row.party_id;
	delete from group_member_index where member_id = row.party_id;
	delete from acs_permissions where grantee_id = row.party_id;
	delete from parties where party_id = row.party_id;

	for row_2 in (select rel_id from acs_rels where object_id_one = row.party_id or object_id_two = row.party_id) loop
		delete from membership_rels where rel_id = row_2.rel_id;
	end loop;

	delete from acs_rels where object_id_one = row.party_id or object_id_two = row.party_id;
	acs_object.delete(row.party_id);
end loop;
end;
/