Below is simple Query to get the Responsibilities attached to user in Oracle Application .It has 1 parameter
- User Name
res.RESPONSIBILITY_NAME
INTO p_resp_name
from
apps.FND_USER usr,
apps.FND_RESPONSIBILITY_TL res,
apps.FND_USER_RESP_GROUPS grp
where 1=1
and grp.responsibility_id = res.responsibility_id
and grp.user_id = usr.user_id
and usr.user_name =p_user_name;
No comments:
Post a Comment