Apps Admin SQL

SELECT b.responsibility_name NAME,u.user_name,employee_id
FROM apps.fnd_user_resp_groups a,
apps.fnd_responsibility_vl b,
apps.fnd_user u
WHERE a.user_id = u.user_id
AND a.responsibility_id = b.responsibility_id
AND a.responsibility_application_id = b.application_id
and b.RESPONSIBILITY_NAME=

To get employee details


select * from per_people_f where person_id =