Oracle Apps Query - List of Users to whom a given responsibility is assigned

Select fu.user_name, fu.start_date user_start_date,fu.end_date user_end_date, fr.responsibility_name, fur.start_date resp_start_date,fur.end_date resp_end_date from FND_USER_RESP_GROUPS_ALL fur, fnd_user fu, fnd_responsibility_vl fr
where sysdate between fur.start_date and nvl(fur.end_date,sysdate)
and sysdate between fu.start_date and nvl(fu.end_date,sysdate)
and fu.user_id = fur.user_id
and fur.responsibility_id = fr.responsibility_id
and fur.responsibility_application_id = fr.application_id
and upper(fr.responsibility_name) = :resp_name