How to get the responisbility key and application short name assigned to user:


SELECT unique r.responsibility_key,
fa.application_short_name
FROM fnd_user u,
fnd_user_resp_groups ur,
fnd_responsibility r,
fnd_application_tl a,
fnd_application fa
WHERE 1=1
AND ur.responsibility_id = r.responsibility_id
AND u.user_id = ur.user_id
AND fa.application_id = a.application_id
AND r.application_id = a.application_id
AND u.user_name = UPPER(:user_name)
ORDER BY 1