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