DBA Data[Home] [Help]

APPS.WFA_SEC dependencies on FND_USER

Line 250: from FND_USER

246: else
247: begin
248: -- user_name should be unique, but use rownum just in case
249: select USER_ID into l_user_id
250: from FND_USER
251: where USER_NAME = PseudoSession.user_name
252: and rownum < 2;
253: exception
254: when NO_DATA_FOUND then

Line 586: FROM FND_USER

582: else
583: if (orig_system = 'PER') then
584: SELECT USER_ID
585: INTO fndUserID
586: FROM FND_USER
587: WHERE USER_NAME = name;
588:
589: else
590: fndUserID := orig_system_ID;

Line 707: FROM FND_USER

703: if (p_orig_system in ('PER', 'FND_USR') ) then
704: if (p_orig_system ='PER') then
705: SELECT USER_ID
706: INTO l_fndUserID
707: FROM FND_USER
708: WHERE USER_NAME = p_role;
709: else
710: l_fndUserID := p_orig_system_id;
711: end if;

Line 811: FROM FND_USER

807: --Bug 2358728A
808: --Obtain the user_id based on the unique user_name
809: SELECT USER_ID
810: INTO l_user_id
811: FROM FND_USER
812: WHERE user_name = Get_Profile_Value.user_name;
813: exception
814: when NO_DATA_FOUND then
815: l_user_id := to_number(null);