DBA Data[Home] [Help]

APPS.GMD_SS_BATCH_WF_PKG dependencies on FND_USER

Line 144: select user_name into l_user from fnd_user

140: if(Approver.user_id is null and Approver.person_id is null) then
141: /* No Approval Required */
142: /* P_resultout:='COMPLETE:N';
143: return; */
144: select user_name into l_user from fnd_user
145: where user_id = l_owner;
146: l_owner_used := 1;
147: end if;
148:

Line 152: select user_name into l_user from fnd_user

148:
149:
150: if (l_user is null) then
151: if(Approver.person_id is null) then
152: select user_name into l_user from fnd_user
153: where user_id=Approver.user_id;
154: else
155: select user_name into l_user from fnd_user
156: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 155: select user_name into l_user from fnd_user

151: if(Approver.person_id is null) then
152: select user_name into l_user from fnd_user
153: where user_id=Approver.user_id;
154: else
155: select user_name into l_user from fnd_user
156: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
157: end if;
158: end if ;
159:

Line 329: select user_name into l_user from fnd_user

325: /* No Approval Required */
326: P_resultout:='COMPLETE:N';
327: else
328: if(Approver.person_id is null) then
329: select user_name into l_user from fnd_user
330: where user_id=Approver.user_id;
331: else
332: select user_name into l_user from fnd_user
333: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 332: select user_name into l_user from fnd_user

328: if(Approver.person_id is null) then
329: select user_name into l_user from fnd_user
330: where user_id=Approver.user_id;
331: else
332: select user_name into l_user from fnd_user
333: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
334: end if;
335:
336: /* Set the User Attribute */