DBA Data[Home] [Help]

APPS.GMD_QM_UOM dependencies on FND_USER

Line 226: from fnd_user

222:
223:
224: cursor get_owner_name (owner_id_in number) is
225: select user_name
226: from fnd_user
227: where user_id = owner_id_in;
228:
229: cursor get_uom_type (uom_code_in varchar2) is
230: select UOM_CLASS from mtl_units_of_measure -- SCHANDRU INVCONV

Line 398: select user_name into l_user from fnd_user

394: if(Approver.user_id is null and Approver.person_id is null) then
395: /* No Approval Required so default to owner*/
396: null ;
397: elsif(Approver.person_id is null) then
398: select user_name into l_user from fnd_user
399: where user_id=Approver.user_id;
400: else
401: select user_name into l_user from fnd_user
402: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 401: select user_name into l_user from fnd_user

397: elsif(Approver.person_id is null) then
398: select user_name into l_user from fnd_user
399: where user_id=Approver.user_id;
400: else
401: select user_name into l_user from fnd_user
402: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
403: end if;
404:
405: IF (l_debug = 'Y') THEN

Line 812: select user_name into l_user from fnd_user

808: /* No Approval Required */
809: P_resultout:='COMPLETE:N';
810: else
811: if(Approver.person_id is null) then
812: select user_name into l_user from fnd_user
813: where user_id=Approver.user_id;
814: else
815: select user_name into l_user from fnd_user
816: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 815: select user_name into l_user from fnd_user

811: if(Approver.person_id is null) then
812: select user_name into l_user from fnd_user
813: where user_id=Approver.user_id;
814: else
815: select user_name into l_user from fnd_user
816: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
817: end if;
818:
819: /* Set the User Attribute */