APPS.AP_WEB_OA_REPORTING_UTIL SQL Statements

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

Line: 91

      l_SqlQry := 'SELECT '||l_CostCenterSegmentName||' FROM GL_CODE_COMBINATIONS '||
                  'WHERE CODE_COMBINATION_ID = :CodeCombinationId';

Line: 140

      SELECT GS.chart_of_accounts_id, S.base_currency_code, S.default_exchange_rate_type
      INTO   l_chart_of_accounts_id, l_base_currency_code, l_exchange_rate_type
      FROM   ap_system_parameters S,
             gl_sets_of_books GS
      WHERE  GS.set_of_books_id = S.set_of_books_id
      AND    rownum = 1;

Line: 172

      SELECT base_currency_code, default_exchange_rate_type
      INTO   P_BaseCurrencyCode, P_ExchangeRateType
      FROM   ap_system_parameters;