What you need to do is to to use sys.sql_dependencies instead of SYSDEPENDS.

Just replace the field in the join and you'll be able to retrieve the info the article refers to. Also, it is better to use xtype instead of type field, type is there for backward compatibility only.

-------------------

SELECT obj.NAME FROM SYSOBJECTS obj

WHERE obj.ID IN

(SELECT DISTINCT DEP.referenced_major_id FROM sys.sql_dependencies DEP

INNER JOIN SYSOBJECTS OBJ

ON OBJ.ID=DEP.referenced_major_id

WHERE obj.NAME = 'Department')

AND obj.XTYPE = 'U'