ERP中查看用户有哪些职责

SELECT papf.last_name,
       uh.user_id,
       uh.user_name,
       hl.responsibility_id,
       tl.responsibility_name,
       hl.responsibility_application_id,
       hl.start_date,
       hl.end_date,
       hl.description
  FROM fnd_user              uh,
       fnd_user_resp_groups  hl,
       fnd_responsibility_tl tl,
       per_all_people_f      papf
 WHERE uh.user_id = hl.user_id
   AND (uh.end_date > SYSDATE OR uh.end_date IS NULL)
   AND hl.responsibility_id = tl.responsibility_id
   AND papf.person_id = uh.employee_id(+)
   AND tl.language = userenv('LANG')
   and  uh.user_name='00447'