DBA Data[Home] [Help]

APPS.FUN_SYSTEM_OPTIONS_PKG SQL Statements

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

Line: 16

      SELECT min_trx_amt, min_trx_amt_currency, default_currency
      INTO l_min_amt, l_min_curr_code, l_def_curr
	  FROM FUN_SYSTEM_OPTIONS
	  WHERE system_option_id = 0;
Line: 36

          SELECT   apar_batch_flag INTO l_apar_batch
	  FROM FUN_SYSTEM_OPTIONS
	  WHERE system_option_id = 0;
Line: 55

          SELECT  gl_batch_flag INTO l_gl_batch
	  FROM FUN_SYSTEM_OPTIONS
	  WHERE system_option_id = 0;
Line: 77

          SELECT  numbering_type INTO l_numbering_type
	  FROM FUN_SYSTEM_OPTIONS
	  WHERE system_option_id = 0;
Line: 99

          SELECT  ALLOW_REJECT_FLAG  INTO l_allow_reject
	  FROM FUN_SYSTEM_OPTIONS
	  WHERE system_option_id = 0;
Line: 121

          SELECT default_currency  INTO l_def_curr
	  FROM FUN_SYSTEM_OPTIONS
	  WHERE system_option_id = 0;
Line: 141

          SELECT exchg_rate_type  INTO l_rate
	  FROM FUN_SYSTEM_OPTIONS
	  WHERE system_option_id = 0;