checking responsibility of user

 select distinct frtl.responsibility_name,fu.user_name,fu.user_id,furgd.start_date Resp_start,furgd.end_date resp_end,fu.start_date USER_start,fu.end_date USER_end
from
apps.fnd_user fu,
apps.fnd_responsibility_tl frtl,
apps.fnd_user_resp_groups_direct furgd
where
fu.user_id=furgd.user_id and
frtl.responsibility_id=furgd.responsibility_id and
fu.user_name='&User'
and frtl.language='US'
and furgd.end_date is null order by 1;