Query to find list of responsibilities assign to user

SELECT

    usr.user_id,

    usr.user_name,

    papf.employee_number,

    papf.full_name,

    resp.responsibility_name,

    resp.responsibility_id,

    resp.application_id,

    furg.security_group_id,

    furg.start_date,

    furg.end_date

FROM

    per_all_people_f          papf,

    fnd_responsibility_tl     resp,

    fnd_user                  usr,

    fnd_user_resp_groups_all  furg

WHERE

        1 = 1

    AND trunc(sysdate) BETWEEN trunc(furg.start_date) AND trunc(nvl(furg.end_date, sysdate))

    AND furg.responsibility_id = resp.responsibility_id

    AND usr.user_id = furg.user_id

    AND papf.person_id = usr.employee_id

    AND trunc(sysdate) BETWEEN trunc(papf.effective_start_date) AND trunc(papf.effective_end_date)

    AND papf.employee_number = 1111111

ORDER BY

    usr.user_id;