APPS.EDW_CURRENCY SQL Statements

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

Line: 22

	Select /*+ FULL(SP) CACHE(SP) */
         warehouse_currency_code, rate_type
        into l_global_currency_code, l_global_rate_type
	From   EDW_LOCAL_SYSTEM_PARAMETERS SP;

Line: 101

		Select currency_code
		From   GL_SETS_OF_BOOKS
		Where  set_of_books_id = x_set_of_books_id;

Line: 166

	Select /*+ FULL(SP) CACHE(SP) */
         warehouse_currency_code, rate_type
        into l_global_currency_code, l_global_rate_type
	From   EDW_LOCAL_SYSTEM_PARAMETERS SP;

Line: 197

  select nvl( curr.minimum_accountable_unit, power( 10, (-1 * curr.precision)))
  into   l_mau
  from   edw_local_system_parameters    lsp,
         gl_currencies                  curr
  where  lsp.warehouse_currency_code = curr.currency_code;