The following lines contain the word 'select', 'insert', 'update' or 'delete':
select units_assigned
into l_units_assigned
from fa_distribution_history
where book_type_code = p_det_balances.book_type_code
and asset_id = p_det_balances.asset_id
and distribution_id = p_det_balances.distribution_id
;
IGI_IAC_ADJUSTMENTS_PKG.insert_row (
x_rowid => l_rowid,
x_adjustment_id => p_det_balances.adjustment_id,
x_book_type_code => p_det_balances.book_type_code,
x_code_combination_id => l_dr_ccid,
x_set_of_books_id => p_set_of_books_id,
x_dr_cr_flag => 'DR',
x_amount => l_amount,
x_adjustment_type => l_dr_adjust_type,
x_transfer_to_gl_flag => p_transfer_to_gl_flag,
x_units_assigned => l_units_assigned,
x_asset_id => p_det_balances.asset_id,
x_distribution_id => p_det_balances.distribution_id,
x_period_counter => p_det_balances.period_counter,
X_adjustment_offset_type => l_cr_adjust_type,
X_report_ccid => l_cr_ccid,
x_mode => 'R',
x_event_id => p_event_id
) ;
IGI_IAC_ADJUSTMENTS_PKG.insert_row (
x_rowid => l_rowid,
x_adjustment_id => p_det_balances.adjustment_id,
x_book_type_code => p_det_balances.book_type_code,
x_code_combination_id => l_cr_ccid,
x_set_of_books_id => p_set_of_books_id,
x_dr_cr_flag => 'CR',
x_amount => l_amount,
x_adjustment_type => l_cr_adjust_type,
x_transfer_to_gl_flag => p_transfer_to_gl_flag,
x_units_assigned => l_units_assigned,
x_asset_id => p_det_balances.asset_id,
x_distribution_id => p_det_balances.distribution_id,
x_period_counter => p_det_balances.period_counter,
X_adjustment_offset_type => l_dr_adjust_type,
X_report_ccid => l_dr_ccid,
x_mode => 'R',
x_event_id => p_event_id
) ;
select transaction_type_code
from igi_iac_transaction_headers
where adjustment_id = fp_det_balances.adjustment_id
;