Query to find Active user Responsibilities.

SELECT
       DISTINCT fu.user_name USER_NAME,
       fu.description  Description,
       pf.Employee_Number,
       fr.responsibility_name, furg.start_date,
       to_char (furg.end_date, 'DD-MON-YYYY HH:MI:SS'),
       fu.email_address,
      fa.application_name,
      hou.NAME
FROM
      APPS.fnd_profile_option_values fpov,
       APPS.fnd_profile_options fpo,
       APPS.hr_operating_units hou,
       APPS.fnd_responsibility_tl fr,
       APPS.fnd_application_tl fa,
       APPS.fnd_user_resp_groups_direct furg,
       APPS.fnd_user fu,
       APPS.per_all_people_f pf
 WHERE
   fpov.profile_option_id = fpo.profile_option_id
   AND fpov.application_id = fpo.application_id
   AND fpo.profile_option_name = 'ORG_ID'
   AND fpov.profile_option_value = TO_CHAR (hou.organization_id)
   AND fpov.level_value = fr.responsibility_id
   AND fa.application_id = fr.application_id
   AND fpov.level_value = fr.responsibility_id
   AND furg.user_id = fu.user_id
   and fu.employee_id=pf.person_id
   AND furg.responsibility_id = fr.responsibility_id
  and ((furg.end_date is null) or (furg.end_date >=sysdate))
  and( fu.end_date >= sysdate or fu.end_date is null)
    order by fu.user_name asc