Index: trunk/ippTools/share/pstamptool_pendingdependent.sql
===================================================================
--- trunk/ippTools/share/pstamptool_pendingdependent.sql	(revision 27739)
+++ trunk/ippTools/share/pstamptool_pendingdependent.sql	(revision 27740)
@@ -1,3 +1,6 @@
-SELECT *
+SELECT DISTINCT pstampDependent.*
 FROM pstampDependent
-WHERE state = 'new'
+JOIN pstampJob USING(dep_id)
+JOIN pstampRequest USING(req_id)
+WHERE pstampDependent.state = 'new'
+    AND pstampJob.state = 'run'
Index: trunk/ippTools/share/pstamptool_revertdependent.sql
===================================================================
--- trunk/ippTools/share/pstamptool_revertdependent.sql	(revision 27740)
+++ trunk/ippTools/share/pstamptool_revertdependent.sql	(revision 27740)
@@ -0,0 +1,4 @@
+UPDATE pstampDependent
+    JOIN pstampJob USING(dep_id)
+    JOIN pstampRequest USING(req_id)
+SET pstampDependent.fault = 0
Index: trunk/ippTools/share/pstamptool_updatejob.sql
===================================================================
--- trunk/ippTools/share/pstamptool_updatejob.sql	(revision 27740)
+++ trunk/ippTools/share/pstamptool_updatejob.sql	(revision 27740)
@@ -0,0 +1,3 @@
+UPDATE pstampJob LEFT JOIN pstampDependent USING(dep_id)
+SET pstampJob.state = '%s'
+    -- set state hook %s