APPS.GMD_SS_LOT_WF_PKG dependencies on FND_USER

Line 176: select user_name into l_user from fnd_user

172: if(Approver.user_id is null and Approver.person_id is null) then
173: /* No Approval Required */
174: /* P_resultout:='COMPLETE:N';
175: return; */
176: select user_name into l_user from fnd_user
177: where user_id = l_owner;
178: l_owner_used := 1;
179: end if;
180:

Line 183: select user_name into l_user from fnd_user

179: end if;
180:
181: if (l_user is null) then
182: if(Approver.person_id is null) then
183: select user_name into l_user from fnd_user
184: where user_id=Approver.user_id;
185: else
186: select user_name into l_user from fnd_user
187: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 186: select user_name into l_user from fnd_user

182: if(Approver.person_id is null) then
183: select user_name into l_user from fnd_user
184: where user_id=Approver.user_id;
185: else
186: select user_name into l_user from fnd_user
187: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
188: end if;
189: end if ;
190:

Line 369: select user_name into l_user from fnd_user

365: /* No Approval Required */
366: P_resultout:='COMPLETE:N';
367: else
368: if(Approver.person_id is null) then
369: select user_name into l_user from fnd_user
370: where user_id=Approver.user_id;
371: else
372: select user_name into l_user from fnd_user
373: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 372: select user_name into l_user from fnd_user

368: if(Approver.person_id is null) then
369: select user_name into l_user from fnd_user
370: where user_id=Approver.user_id;
371: else
372: select user_name into l_user from fnd_user
373: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
374: end if;
375:
376: /* Set the User Attribute */