try this as a start select
pred.prexternalid
, pred.prname
, dtype.name
, succ.prexternalid
, succ.prname
, dep.*
from prdependency dep
join prtask pred on pred.prid = dep.prpredtaskid
join prtask succ on succ.prid = dep.prsucctaskid
-- check data type of dtype.lookup_code = dep.prtype
join cmn_lookups_v dtype on (dtype.lookup_code = dep.prtype and lookup_type = 'prDependencyType' and language_code = 'en')