DBA Data[Home] [Help]

APPS.GMD_QMREJ dependencies on FND_USER

Line 240: select user_name into l_user from fnd_user where user_id=Approver.user_id;

236: null ;
237: else /* No approvers */
238:
239: if(Approver.person_id is null) then
240: select user_name into l_user from fnd_user where user_id=Approver.user_id;
241: else
242: select user_name into l_user from fnd_user where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
243: end if;
244:

Line 242: select user_name into l_user from fnd_user where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

238:
239: if(Approver.person_id is null) then
240: select user_name into l_user from fnd_user where user_id=Approver.user_id;
241: else
242: select user_name into l_user from fnd_user where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
243: end if;
244:
245: IF (l_debug = 'Y') THEN
246: gmd_debug.put_line('Found approvers ');

Line 426: select user_name into l_user from fnd_user

422: /* No Approval Required */
423: P_resultout:='COMPLETE:N';
424: else
425: if(Approver.person_id is null) then
426: select user_name into l_user from fnd_user
427: where user_id=Approver.user_id;
428: else
429: select user_name into l_user from fnd_user
430: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 429: select user_name into l_user from fnd_user

425: if(Approver.person_id is null) then
426: select user_name into l_user from fnd_user
427: where user_id=Approver.user_id;
428: else
429: select user_name into l_user from fnd_user
430: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
431: end if;
432:
433: /* Set the User Attribute */