Get List of responsibilities assigned to a user
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
select fu.user_name, frt.responsibility_name, furg.start_date, furg.end_date from fnd_user fu , fnd_user_resp_groups_direct furg , fnd_responsibility_vl frt where fu.user_id = furg.user_id and frt.responsibility_id = furg.responsibility_id and frt.application_id = furg.responsibility_application_id and nvl(furg.end_date,sysdate+1) > sysdate and nvl(frt.end_date,sysdate +1) > sysdate and fu.user_name = :p_user_name –and fu.user_name = :p_userid; ; |