Oracle ebs finds users through responsibilities
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%'
