APPS.FND_SOS_SERVICE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

                SELECT LANGUAGE_CODE
                FROM   fnd_languages
                WHERE  INSTALLED_FLAG='I';

Line: 60

        SELECT user_id,description,ENCRYPTED_USER_PASSWORD
        INTO   user_id,description,enc_pwd
        FROM   fnd_user
        WHERE  UPPER(user_name)=UPPER(p_user_name);

Line: 78

        SELECT xsid
        INTO   xsid
        FROM   icx_sessions
        WHERE  session_id=sess_id;

Line: 88

        SELECT language_code
	INTO   languages
	FROM   fnd_languages
        WHERE  nls_language = upper(p_lang);

Line: 116

                SELECT session_id
                FROM   icx_sessions
                WHERE  user_id=
                       (SELECT user_id
                       FROM    fnd_user
                       WHERE   user_name=UPPER(p_user_name)
                       )
           AND xsid         =p_password
           AND disabled_flag='N';