DBA Data[Home] [Help]

APPS.GMD_QMTES dependencies on FND_USER

Line 203: select user_name into l_user from fnd_user

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

Line 206: select user_name into l_user from fnd_user

202: if(Approver.person_id is null) then
203: select user_name into l_user from fnd_user
204: where user_id=Approver.user_id;
205: else
206: select user_name into l_user from fnd_user
207: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
208: end if;
209:
210:

Line 409: select user_name into l_user from fnd_user

405: /* No Approval Required */
406: P_resultout:='COMPLETE:N';
407: else
408: if(Approver.person_id is null) then
409: select user_name into l_user from fnd_user
410: where user_id=Approver.user_id;
411: else
412: select user_name into l_user from fnd_user
413: where

Line 412: select user_name into l_user from fnd_user

408: if(Approver.person_id is null) then
409: select user_name into l_user from fnd_user
410: where user_id=Approver.user_id;
411: else
412: select user_name into l_user from fnd_user
413: where
414: user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
415: end if;
416: