DBA Data[Home] [Help]

APPS.WFA_SEC dependencies on FND_USER

Line 261: from FND_USER

257: else
258: begin
259: -- user_name should be unique, but use rownum just in case
260: select USER_ID into l_user_id
261: from FND_USER
262: where USER_NAME = PseudoSession.user_name
263: and rownum < 2;
264: exception
265: when NO_DATA_FOUND then

Line 600: FROM FND_USER

596: else
597: if (orig_system = 'PER') then
598: SELECT USER_ID
599: INTO fndUserID
600: FROM FND_USER
601: WHERE USER_NAME = name;
602:
603: else
604: fndUserID := orig_system_ID;

Line 719: FROM FND_USER

715: if (p_orig_system in ('PER', 'FND_USR') ) then
716: if (p_orig_system ='PER') then
717: SELECT USER_ID
718: INTO l_fndUserID
719: FROM FND_USER
720: WHERE USER_NAME = p_role;
721: else
722: l_fndUserID := p_orig_system_id;
723: end if;

Line 819: FROM FND_USER

815: --Bug 2358728A
816: --Obtain the user_id based on the unique user_name
817: SELECT USER_ID
818: INTO l_user_id
819: FROM FND_USER
820: WHERE user_name = Get_Profile_Value.user_name;
821: exception
822: when NO_DATA_FOUND then
823: l_user_id := to_number(null);