Query to Get Custom Responsibilities

SELECT fr.responsibility_id, frt.responsibility_name, fr.created_by

  FROM fnd_responsibility fr,

       fnd_responsibility_tl frt,

       fnd_application fa,

       fnd_application_tl fat

 WHERE fr.responsibility_id = frt.responsibility_id

       AND TRUNC (SYSDATE) BETWEEN fr.start_date

                               AND NVL (fr.end_date, hr_general.end_of_time)

       AND frt.language = 'US'

       AND fa.application_id = fr.application_id

       AND fa.application_id = fat.application_id

       AND fat.language = 'US'

       --AND UPPER (fat.application_name) IN ('HUMAN RESOURCES', 'PAYROLL')

       AND fr.created_by NOT IN (0, 1, 2, 120, 121, 122)