APPS.ISG_BPEL_CTX_PKG SQL Statements

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

Line: 12

         	SELECT language_code
        	INTO   ISG_BPEL_CTX_PKG.pAppsBaseLang
        	FROM   fnd_languages
        	WHERE  Installed_flag = 'B';

Line: 29

                            SELECT language_code
                            INTO   lang_code
                            FROM   fnd_languages
                            WHERE  nls_language = pTemp
                            and Installed_flag in ('B','I');

Line: 59

SELECT isg_code
INTO pISGErrorCode
FROM error_codes_map
WHERE adapter_code = pAdapterErrorCode;

Line: 68

SELECT description
INTO pResolution
FROM error_codes_map
WHERE adapter_code = pAdapterErrorCode;

Line: 75

SELECT user_id
INTO pUserID
FROM fnd_user
WHERE user_name = upper(pUserName);

Line: 83

SELECT language_code
INTO   pLangCode
FROM   fnd_languages
WHERE  nls_language = upper(pLang)
and Installed_flag in ('B','I');

Line: 89

SELECT message_text
INTO pISGErrorMsg
FROM fnd_new_messages
WHERE message_name = pISGErrorCode
AND  language_code = pLangCode;