-- get list of responsibilities available to any user

select * from FND_USER_RESP_GROUPS furs, fnd_user fu , fnd_responsibility_vl fr
where 1=1
and fu.user_id=furs.user_id
and user_name='ACNIC22'
and fr.responsibility_id=furs.responsibility_id