SQL & PL/SQL :: Show A List Of All Users And Responsibilities

We're trying to use the SQL statement below to show a list of all users and responsibilities however it is only returning employee accounts. For example, the GUEST account is not listed in the results. It also isn't showing us the users who've been end dated, only the users with current accounts. I think one of the AND statements is the problem. What should I change below to achieve the desired results: A list of all users and responsibilities including system and disabled user accounts.

SQL Statement

SELECT a.application_id, a.responsibility_id, d.user_id, e.application_name,
b.responsibility_name, logons.last_access, a.responsibility_key, b.description,
a.end_date, c.end_date user_resp_end_date, d.user_name,
d.end_date user_end_date, d.description NAME, per.department,
per.job_title, per.eeo_worksite worksite, per.LOCATION
FROM apps.fnd_responsibility a,
[code]....