--- this responsibility is with which user ?

select responsibility_name, user_name, fu.description ,furs.* from fnd_responsibility_tl fr,
fnd_user fu,
FND_USER_RESP_GROUPS furs
where 1=1
and fu.user_id=furs.user_id
and responsibility_name='HBC NZOOM Office'
and fr.responsibility_id=furs.responsibility_id
and nvl(furs.end_Date,'31-DEC-4712') > sysdate
and fr.LANGUAGE='US'