Find List of Responsibilities attached to User

SELECT b.user_name,
c.responsibility_name,
a.START_DATE,
a.END_DATE
FROM apps.fnd_user_resp_groups_direct a, apps.fnd_user b, apps.fnd_responsibility_tl c
WHERE a.user_id = b.user_id
AND a.responsibility_id = c.responsibility_id
AND c.language = 'US'
AND b.user_name = :username

Advertisements