Query to get Users Information Based on the given Responsibility

Following query will give Users Information who are assigned with the Responsibility which is passed as Parameter (P_RESPONSIBILITY_NAME).

select frt.responsibility_id, frt.responsibility_name, fu.user_name, to_char(fu.start_date,'DD-MON-YYYY') "Start Date",to_char(fu.end_date,'DD-MON-YYYY') "End Date"
from fnd_responsibility_tl frt
,fnd_user_resp_groups furg
,fnd_user fu
where 1 = 1
  and UPPER(frt.responsibility_name) like UPPER('&P_RESPONSIBILITY_NAME')
  and furg.responsibility_id = frt.responsibility_id
  and fu.user_id = furg.user_id;