DBA Data[Home] [Help]

APPS.GMD_QMTES dependencies on FND_USER

Line 207: select user_name into l_user from fnd_user

203: gmd_debug.put_line('Approvers Found');
204: END IF;
205:
206: if(Approver.person_id is null) then
207: select user_name into l_user from fnd_user
208: where user_id=Approver.user_id;
209: else
210: select user_name into l_user from fnd_user
211: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 210: select user_name into l_user from fnd_user

206: if(Approver.person_id is null) then
207: select user_name into l_user from fnd_user
208: where user_id=Approver.user_id;
209: else
210: select user_name into l_user from fnd_user
211: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
212: end if;
213:
214:

Line 417: select user_name into l_user from fnd_user

413: /* No Approval Required */
414: P_resultout:='COMPLETE:N';
415: else
416: if(Approver.person_id is null) then
417: select user_name into l_user from fnd_user
418: where user_id=Approver.user_id;
419: else
420: select user_name into l_user from fnd_user
421: where

Line 420: select user_name into l_user from fnd_user

416: if(Approver.person_id is null) then
417: select user_name into l_user from fnd_user
418: where user_id=Approver.user_id;
419: else
420: select user_name into l_user from fnd_user
421: where
422: user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
423: end if;
424: