APPS.MRP_PO_RESCHEDULE dependencies on FND_USER

Line 173: FROM FND_USER

169: BEGIN
170:
171: SELECT USER_ID
172: INTO l_user_id
173: FROM FND_USER
174: WHERE USER_NAME = p_user_name;
175:
176: EXCEPTION
177: WHEN NO_DATA_FOUND THEN

Line 196: FROM FND_USER

192: l_appl_id := 724;
193:
194: SELECT USER_ID
195: INTO l_user_id
196: FROM FND_USER
197: WHERE USER_NAME = p_user_name;
198:
199: SELECT responsibility_id
200: INTO l_resp_id

Line 556: fnd_user_resp_groups user_resp

552: l_appl_id number) IS
553: SELECT level_value
554: FROM fnd_profile_options opt,
555: fnd_profile_option_values opt_vals,
556: fnd_user_resp_groups user_resp
557: WHERE opt.profile_option_name = 'ORG_ID'
558: AND opt.profile_option_id = opt_vals.profile_option_id
559: AND opt_vals.profile_option_value = to_char(l_org_id)
560: AND opt_vals.level_id = 10003 -- responsibility level