SELECT user_id, user_name, NAME, responsibility_name, responsibility_id,
              application_id, last_resp_accessed, creation_date
       FROM  ( SELECT fu.user_id, fu.user_name, NVL (fu.description, papf.full_name) NAME,
                      frt.responsibility_name, furgd.creation_date,
                      frt.responsibility_id, frt.application_id,
                      (SELECT NVL (TRUNC (MAX (sess.creation_date)),
                                  '01-JAN-1900' ) login_date
                       FROM   icx_sessions sess
                       WHERE  fu.user_id = sess.user_id
                       AND    sess.responsibility_id = fr.responsibility_id) last_resp_accessed
               FROM  fnd_responsibility_tl frt,
                     fnd_responsibility fr,
                     fnd_user fu,
                     fnd_user_resp_groups_direct furgd,
                     per_all_people_f papf
               WHERE frt.responsibility_id = fr.responsibility_id
               AND   fr.application_id = frt.application_id
               AND   frt.responsibility_id = furgd.responsibility_id
               AND   fu.user_id = furgd.user_id
               AND   fu.user_name = papf.employee_number
               AND   (fu.end_date IS NULL OR fu.end_date > SYSDATE)
               AND   (furgd.end_date IS NULL OR furgd.end_date > SYSDATE))
       WHERE LAST_RESP_ACCESSED < SYSDATE - :No_of_Days_user_did_not_Access