DBA Data[Home] [Help]

APPS.BIS_REPORT_UTIL_PVT SQL Statements

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

Line: 101

	SELECT l.language_code
              INTO l_NLS_Language_Code
	FROM fnd_languages l,
              nls_session_parameters p
        WHERE p.parameter = 'NLS_LANGUAGE'
        AND   p.value = l.nls_language;
Line: 128

	SELECT user_function_name
	INTO   l_Report_Title
	FROM   fnd_form_functions_vl vl,
	       fnd_form_functions ff
	WHERE  ff.function_id = vl.function_id
	AND    ff.function_name = p_Function_Code;
Line: 196

	SELECT meaning, description
        INTO   x_Icon_Meaning,
   	       x_Icon_Description
        FROM   fnd_lookups
        WHERE  lookup_code = p_Icon_Code
        AND    lookup_type = 'HTML_NAVIGATION_ICONS';
Line: 598

		 Please specify the parameter(s) and select OK.
		
		
		
');
Line: 1093

	select symbol, description
	       into v_currencySymbol, v_currencyDescr
		   from fnd_currencies
		   where CURRENCY_CODE = v_functionalCurrency;