SQL Query to list Active Responsibilities assigned to Active User

/***********************************************************

*PURPOSE: To list Active Responsibilities assigned to Active user *
*PARAMETER: User Name *
******************************************************************/
SELECT fu.user_name,
frv.responsibility_name,
TO_CHAR
(furgd.start_date,
'DD-MON-RRRR) "START_DATE",
TO_CHAR
(furgd.end_date,
'DD-MON-RRRR') "END_DATE"
FROM fnd_user fu,
fnd_user_resp_groups_direct furgd,
fnd_responsibility_vl frv
WHERE fu.user_id = furgd.user_id
AND furgd.responsibility_id = frv.responsibility_id
AND furgd.end_date IS
NULL
AND fu.user_name =
'&user_name'
AND furgd.start_date <=
SYSDATE
AND
NVL
(furgd.end_date,
SYSDATE
+
1)>
SYSDATE
AND fu.start_date              <=
SYSDATE
AND
NVL
(fu.end_date,
SYSDATE
+
1)
>
SYSDATE
AND frv.start_date <=
SYSDATE

AND
NVL
(frv.end_date,
SYSDATE
+
1)
>
SYSDATE;

 

The above query will return results if all the conditions given below are satisfied.

1) User must be active.
2) Responsibility must be active.
3) Assignment of Responsibility to a user must be active.