SELECT fu.user_name FROM FND_USER_RESP_GROUPS fur, fnd_responsibility_tl fr, fnd_user fu WHERE fr.language = 'US' AND fr.responsibility_name LIKE :responsibility_name AND fr.responsibility_id = fur.responsibility_id AND fu.user_id = fur.user_id
No comments:
Post a Comment