DBA Data[Home] [Help]

APPS.MSC_X_CP_FLOW dependencies on FND_USER

Line 124: , fnd_user_resp_groups furg

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

Line 126: , fnd_user fu

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
129: and furg.user_id = mcu.user_id
130: and mcu.user_id = fu.user_id

Line 386: , fnd_user_resp_groups furg

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

Line 388: , fnd_user fu

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
391: and furg.user_id = mcu.user_id
392: and mcu.user_id = fu.user_id