SELECT MAX(p.changedDateTime) 
  INTO :changedDateTime 
  FROM Dependency d INNER JOIN PrecedentChangeItem p 
     ON d.precedentType = p.precedentType
    AND d.precedentID = p.precedentID 
    WHERE d.dependentType = :dependentType
      AND d.dependentID = :caseID
      AND p.precedentChangeSetID IN (
        SELECT precedentChangeSetID from PrecedentChangeSetBatchCtrl pcsc WHERE pcsc.status = :statusCode1 OR pcsc.status = :statusCode2
      )