Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 27794)
+++ trunk/ippTools/share/Makefile.am	(revision 27795)
@@ -114,5 +114,6 @@
      difftool_pendingcleanupskyfile.sql \
      difftool_revertdiffskyfile_delete.sql \
-     difftool_revertdiffskyfile_update.sql \
+     difftool_revertdiffskyfile_updated.sql \
+     difftool_setskyfiletoupdate.sql \
      difftool_skyfile.sql \
      difftool_todiffskyfile.sql \
@@ -223,4 +224,5 @@
      pstamptool_completedreq.sql \
      pstamptool_datastore.sql \
+     pstamptool_getdependent.sql \
      pstamptool_listjob.sql \
      pstamptool_pendingdependent.sql \
Index: trunk/ippTools/share/pstamptool_getdependent.sql
===================================================================
--- trunk/ippTools/share/pstamptool_getdependent.sql	(revision 27795)
+++ trunk/ippTools/share/pstamptool_getdependent.sql	(revision 27795)
@@ -0,0 +1,5 @@
+SELECT DISTINCT pstampDependent.*
+FROM pstampDependent
+JOIN pstampJob USING(dep_id)
+JOIN pstampRequest USING(req_id)
+WHERE pstampDependent.state = 'new'
Index: trunk/ippTools/share/pstamptool_pendingdependent.sql
===================================================================
--- trunk/ippTools/share/pstamptool_pendingdependent.sql	(revision 27794)
+++ trunk/ippTools/share/pstamptool_pendingdependent.sql	(revision 27795)
@@ -4,3 +4,5 @@
 JOIN pstampRequest USING(req_id)
 WHERE pstampDependent.state = 'new'
+    AND pstampDependent.fault = 0
     AND pstampJob.state = 'run'
+    AND pstampRequest.state = 'run'
Index: trunk/ippTools/share/pstamptool_revertdependent.sql
===================================================================
--- trunk/ippTools/share/pstamptool_revertdependent.sql	(revision 27794)
+++ trunk/ippTools/share/pstamptool_revertdependent.sql	(revision 27795)
@@ -3,2 +3,3 @@
     JOIN pstampRequest USING(req_id)
 SET pstampDependent.fault = 0
+WHERE pstampDependent.state = 'new'