Query to find the Direct Responsibilities attached to a User

select
urg.user_id,
fu.user_name,
urg.responsibility_id,
fr.responsibility_name
from
fnd_user_resp_groups_direct urg,
fnd_responsibility_tl fr,
fnd_user fu
where
urg.user_id=fu.user_id and
urg.responsibility_id=fr.responsibility_id and
fu.user_name='<user_name>'