Oracle EBS looks for users through responsibility

SELECT DISTINCT papf.person_id,
Papf.employee_number,
Papf.full_name,
SU.USER_ID,
RES.RESPONSIBILITY_ID,
RES.APPLICATION_ID,
Su.user_name,
Res.responsibility_name
From Hr.per_all_people_f Papf,
Applsys.fnd_user Su,
FND_RESPONSIBILITY_VL Res,
Fnd_user_resp_groups_all Furg,
FND_APPLICATION_VL app
WHERE
su.employee_id = papf.person_id (+)
and su.user_id = furg.user_id
and res.responsibility_id = furg.responsibility_id
and res.application_id = furg.responsibility_application_id
and furg.responsibility_application_id = app.application_id
and res.responsibility_name like '%responsibility_name% ';

This article is from the "joyous blog" blog, please be sure to keep this source http://joyous.blog.51cto.com/9184276/1440969

Oracle EBS looks for users through responsibility