Postgres Join multiple table to replace id of parent table with value
This is what you want:

select *
from dependency as d
join service as s on d.service = s.s_id 
join service_type as st on s.s_type = st.id 
join dependency_type as dt on d.dependency_type = dt.id; 


dbfiddle here.