120: p_resp_key varchar2
121: ) IS
122: SELECT fu.user_name name
123: FROM fnd_responsibility resp
124: , fnd_user_resp_groups furg
125: , msc_company_users mcu
126: , fnd_user fu
127: WHERE resp.responsibility_key = p_resp_key
128: AND furg.responsibility_id = resp.responsibility_id
382: p_resp_key varchar2
383: ) IS
384: SELECT fu.user_name name
385: FROM fnd_responsibility resp
386: , fnd_user_resp_groups furg
387: , msc_company_users mcu
388: , fnd_user fu
389: WHERE resp.responsibility_key = p_resp_key
390: AND furg.responsibility_id = resp.responsibility_id