Query to retrieve active responsibilities assigned to a user

Input : User Name

select distinct fu.user_name "User Name", fu.description "User Full Name", frv.responsibility_name "Responsibility Name", fur.start_date "Resp Assignment Start Date", fur.end_date "Resp Assignment End Date" from fnd_responsibility_vl frv, fnd_user_resp_groups_direct fur, fnd_user fu where fur.responsibility_id=frv.responsibility_id and fu.user_id=fur.user_id AND SYSDATE BETWEEN fu.start_date AND NVL(fu.end_date,SYSDATE) AND SYSDATE BETWEEN frv.start_date AND NVL(frv.end_date,SYSDATE) and fu.user_name=:User_name order by frv.responsibility_name ;