DBA Data[Home] [Help]

APPS.GMD_SS_LATETEST_WF_PKG dependencies on FND_USER

Line 182: select user_name into l_user from fnd_user

178:
179: if(Approver.user_id is null and Approver.person_id is null) then
180: /* No Approval Required so we will default to the owner*/
181: /* P_resultout:='COMPLETE:N'; */
182: select user_name into l_user from fnd_user
183: where user_id = l_owner;
184: l_owner_used := 1;
185: end if ;
186:

Line 189: select user_name into l_user from fnd_user

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

Line 192: select user_name into l_user from fnd_user

188: if(Approver.person_id is null) then
189: select user_name into l_user from fnd_user
190: where user_id=Approver.user_id;
191: else
192: select user_name into l_user from fnd_user
193: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
194: end if;
195: end if;
196:

Line 374: select user_name into l_user from fnd_user

370: /* No Approval Required */
371: P_resultout:='COMPLETE:N';
372: else
373: if(Approver.person_id is null) then
374: select user_name into l_user from fnd_user
375: where user_id=Approver.user_id;
376: else
377: select user_name into l_user from fnd_user
378: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 377: select user_name into l_user from fnd_user

373: if(Approver.person_id is null) then
374: select user_name into l_user from fnd_user
375: where user_id=Approver.user_id;
376: else
377: select user_name into l_user from fnd_user
378: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
379: end if;
380:
381: /* Set the User Attribute */