X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=remove_ou_data%2F18_delete_usrs_stage_3.sql;fp=remove_ou_data%2F18_delete_usrs_stage_3.sql;h=47518a474a2fd5107cb7b7cd94dec05abfe68db8;hp=09cc9d2269f2acb2a49eae435f693040fef4167d;hb=6aa25bdacac4eab43e1993a55704c94b1fcf311a;hpb=6fb82d8e89954195400ae834f2b452865671dff8

diff --git a/remove_ou_data/18_delete_usrs_stage_3.sql b/remove_ou_data/18_delete_usrs_stage_3.sql
index 09cc9d2..47518a4 100644
--- a/remove_ou_data/18_delete_usrs_stage_3.sql
+++ b/remove_ou_data/18_delete_usrs_stage_3.sql
@@ -22,8 +22,8 @@
 SELECT id
 FROM actor.usr WHERE home_ou IN (
     SELECT (actor.org_unit_descendants(id)).id FROM actor.org_unit
-    WHERE shortname IN (SELECT shortname FROM esi.ous_to_del)
-);
+    WHERE shortname = :ou_to_del
+) ;
 
 
 -- find the problems and clear them up