Get Logged-in/Session User in IFS

SELECT Fnd_Session_API.Get_Fnd_User FROM DUAL;