APPS.MRP_PO_RESCHEDULE dependencies on FND_USER

Line 164: FROM FND_USER

160: BEGIN
161:
162: SELECT USER_ID
163: INTO l_user_id
164: FROM FND_USER
165: WHERE USER_NAME = p_user_name;
166:
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN

Line 187: FROM FND_USER

183: l_appl_id := 724;
184:
185: SELECT USER_ID
186: INTO l_user_id
187: FROM FND_USER
188: WHERE USER_NAME = p_user_name;
189:
190: SELECT responsibility_id
191: INTO l_resp_id

Line 546: fnd_user_resp_groups user_resp

542: l_appl_id number) IS
543: SELECT level_value
544: FROM fnd_profile_options opt,
545: fnd_profile_option_values opt_vals,
546: fnd_user_resp_groups user_resp
547: WHERE opt.profile_option_name = 'ORG_ID'
548: AND opt.profile_option_id = opt_vals.profile_option_id
549: AND opt_vals.profile_option_value = to_char(l_org_id)
550: AND opt_vals.level_id = 10003 -- responsibility level