-- This is to list the  Apps User who are assigned a particular responsibility

select a.user_name,b.responsibility_name 

from

fnd_user a,fnd_responsibility_vl b ,FND_USER_RESP_GROUPS c

where

a.user_id = c.user_id

and

c.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID

and lower(b.responsibility_name) like lower('&Responsibility_name%')

and a.END_DATE is null

and

(c.END_DATE is null

or

c.end_date > sysdate)

group by a.USER_NAME,b.RESPONSIBILITY_NAME