The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
cep_standard.debug('call CE_SYSTEM_PARAMETERS1_PKG.select_columns');
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
);
cep_standard.debug('end call CE_SYSTEM_PARAMETERS1_PKG.select_columns');
select mo_global.GET_CURRENT_ORG_ID
into current_org_id
from dual;
select mo_global.GET_CURRENT_ORG_ID
into current_org_id
from dual;
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;