APPS.CE_AUTO_BANK_REC SQL Statements

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

Line: 39

  SELECT 1
  INTO   dummy
  FROM   gl_period_statuses
  WHERE  application_id = p_app_id
  AND    set_of_books_id = CE_AUTO_BANK_REC.G_set_of_books_id
  AND    adjustment_period_flag = 'N'
  AND    closing_status in ('O','F')
  AND    p_date between start_date and end_date;

Line: 295

    cep_standard.debug('call CE_SYSTEM_PARAMETERS1_PKG.select_columns');

Line: 302

    CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
				CE_AUTO_BANK_REC.G_set_of_books_id,
				CE_AUTO_BANK_REC.G_cashbook_begin_date,
				CE_AUTO_BANK_REC.G_show_cleared_flag,
                                CE_AUTO_BANK_REC.G_show_void_payment_flag,
				CE_AUTO_BANK_REC.G_line_autocreation_flag,
			 	CE_AUTO_BANK_REC.G_interface_purge_flag,
				CE_AUTO_BANK_REC.G_interface_archive_flag,
				CE_AUTO_BANK_REC.G_lines_per_commit,
				CE_AUTO_BANK_REC.G_functional_currency,
				CE_AUTO_BANK_REC.G_sob_short_name,
				CE_AUTO_BANK_REC.G_account_period_type,
				CE_AUTO_BANK_REC.G_user_exchange_rate_type,
				CE_AUTO_BANK_REC.G_chart_of_accounts_id,
				CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
				CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
				CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
                                CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
				CE_AUTO_BANK_REC.G_legal_entity_id
			);

Line: 325

    cep_standard.debug('end call CE_SYSTEM_PARAMETERS1_PKG.select_columns');

Line: 330

  select mo_global.GET_CURRENT_ORG_ID
  into current_org_id
  from dual;

Line: 351

  select mo_global.GET_CURRENT_ORG_ID
  into current_org_id
  from dual;

Line: 359

    select liability_tax_code, asset_tax_code
    into   CE_AUTO_BANK_REC.G_dr_vat_tax_code,
	   CE_AUTO_BANK_REC.G_cr_vat_tax_code
    from ar_receivables_trx
    where receivables_trx_id = CE_AUTO_BANK_REC.G_receivables_trx_id;