[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select bk.asset_id,
bk.transaction_header_id_in,
bk.rowid,
th.transaction_type_code,
th.transaction_date_entered,
th.transaction_subtype,
th.transaction_key,
th.amortization_start_date,
th.calling_interface,
th.member_transaction_header_id,
th.trx_reference_id,
th.event_id
from fa_books bk,
fa_transaction_headers th
where bk.asset_id in (l_source_asset_id, l_dest_asset_id)
and bk.book_type_code = p_book
and bk.adjustment_required_status = 'GADJ'
and bk.date_ineffective is null
and th.transaction_header_id = bk.transaction_header_id_in
order by bk.transaction_header_id_in;
select bk.asset_id,
bk.transaction_header_id_in,
bk.rowid,
th.transaction_type_code,
th.transaction_date_entered,
th.transaction_subtype,
th.transaction_key,
th.amortization_start_date,
th.calling_interface,
th.member_transaction_header_id,
th.trx_reference_id,
th.event_id
from fa_books bk,
fa_transaction_headers th
where bk.book_type_code = p_book
and bk.adjustment_required_status = 'GADJ'
and bk.date_ineffective is null
and th.transaction_header_id = bk.transaction_header_id_in
order by bk.transaction_header_id_in;
select transaction_header_id_in
from fa_books
where asset_id = l_asset_id
and book_type_code = p_book
and transaction_header_id_out = l_trx_id_in;
select count(*)
from fa_books
where transaction_header_id_in = l_trx_id_in
and adjustment_required_status = 'GADJ';
select count(*)
from fa_mc_books
where transaction_header_id_in = l_trx_id_in
and set_of_books_id = l_asset_hdr_rec.set_of_books_id
and adjustment_required_status = 'GADJ';
select TRX_REFERENCE_ID,
TRANSACTION_TYPE,
SRC_TRANSACTION_SUBTYPE,
DEST_TRANSACTION_SUBTYPE,
BOOK_TYPE_CODE,
SRC_ASSET_ID,
SRC_TRANSACTION_HEADER_ID,
DEST_ASSET_ID,
DEST_TRANSACTION_HEADER_ID,
MEMBER_ASSET_ID,
MEMBER_TRANSACTION_HEADER_ID,
SRC_AMORTIZATION_START_DATE,
DEST_AMORTIZATION_START_DATE,
RESERVE_TRANSFER_AMOUNT,
SRC_EXPENSE_AMOUNT,
DEST_EXPENSE_AMOUNT,
SRC_EOFY_RESERVE,
DEST_EOFY_RESERVE
from fa_trx_references
where TRX_REFERENCE_ID = l_trans_rec.trx_reference_id;
select decode(debit_credit_flag,'DR',adjustment_amount,'CR',-1*adjustment_amount) /*Bug#9684024 */
from fa_adjustments
where asset_id = l_asset_hdr_rec.asset_id
and book_type_code = l_asset_hdr_rec.book_type_code
and transaction_header_id = l_trans_rec.transaction_header_id;
select decode(debit_credit_flag,'DR',adjustment_amount,'CR',-1*adjustment_amount)
from fa_mc_adjustments
where asset_id = l_asset_hdr_rec.asset_id
and book_type_code = l_asset_hdr_rec.book_type_code
and transaction_header_id = l_trans_rec.transaction_header_id
and set_of_books_id = l_asset_hdr_rec.set_of_books_id;
select nvl(reserve_retired, 0)
from fa_retirements
where transaction_header_id_in = l_trans_rec.member_transaction_header_id;
select nvl(reserve_retired, 0)
from fa_mc_retirements
where transaction_header_id_in = l_trans_rec.member_transaction_header_id
and set_of_books_id = l_asset_hdr_rec.set_of_books_id;
select nvl(reserve_retired, 0)
, transaction_header_id_in
from fa_retirements
where transaction_header_id_out = l_trans_rec.member_transaction_header_id;
select nvl(reserve_retired, 0)
, transaction_header_id_in
from fa_mc_retirements
where transaction_header_id_out = l_trans_rec.member_transaction_header_id
and set_of_books_id = l_asset_hdr_rec.set_of_books_id;
select sum(decode(debit_credit_flag, 'CR', -1, 1) *
decode(l_trans_rec.transaction_key, 'MR', 1, -1) *
adjustment_amount)
from fa_adjustments
where asset_id = l_asset_hdr_rec.asset_id
and book_type_code = l_asset_hdr_rec.book_type_code
and transaction_header_id = l_trans_rec.transaction_header_id
and adjustment_type = 'RESERVE';
select sum(decode(debit_credit_flag, 'CR', -1, 1) *
decode(l_trans_rec.transaction_key, 'MR', 1, -1) *
adjustment_amount)
from fa_mc_adjustments
where asset_id = l_asset_hdr_rec.asset_id
and book_type_code = l_asset_hdr_rec.book_type_code
and transaction_header_id = l_trans_rec.transaction_header_id
and adjustment_type = 'RESERVE'
and set_of_books_id = l_asset_hdr_rec.set_of_books_id;
select th.asset_id
, th.transaction_header_id
, th.transaction_type_code
, th.transaction_date_entered
, th.transaction_name
, th.source_transaction_header_id
, th.mass_reference_id
, th.transaction_subtype
, th.transaction_key
, th.amortization_start_date
, th.calling_interface
, th.mass_transaction_id
, th.member_transaction_header_id
, th.trx_reference_id
, th.last_update_date
, th.last_updated_by
, th.last_update_login
, th.event_id
, tr.transaction_type
from fa_transaction_headers th,
fa_trx_references tr --Added for bug 537059
where th.transaction_header_id = l_trans_rec.member_transaction_header_id
and tr.trx_reference_id(+) = th.trx_reference_id; --Added for bug 537059
SELECT SRC_ASSET_ID,
BOOK_TYPE_CODE,
SRC_TRANSACTION_HEADER_ID,
SRC_TRANSACTION_SUBTYPE,
SRC_AMORTIZATION_START_DATE,
TRX_REFERENCE_ID,
EVENT_ID,
DEST_ASSET_ID,
BOOK_TYPE_CODE,
DEST_TRANSACTION_HEADER_ID,
DEST_TRANSACTION_SUBTYPE,
DEST_AMORTIZATION_START_DATE,
TRX_REFERENCE_ID,
EVENT_ID,
TRANSACTION_TYPE,
INVOICE_TRANSACTION_ID
FROM FA_TRX_REFERENCES
WHERE SRC_TRANSACTION_HEADER_ID = P_TRX_NUMBER;
SELECT PO_VENDOR_ID,
ASSET_INVOICE_ID,
FIXED_ASSETS_COST,
DELETED_FLAG,
PO_NUMBER,
INVOICE_NUMBER,
PAYABLES_BATCH_NAME,
PAYABLES_CODE_COMBINATION_ID,
FEEDER_SYSTEM_NAME,
CREATE_BATCH_DATE,
CREATE_BATCH_ID,
INVOICE_DATE,
PAYABLES_COST,
POST_BATCH_ID,
INVOICE_ID,
AP_DISTRIBUTION_LINE_NUMBER,
PAYABLES_UNITS,
SPLIT_MERGED_CODE,
DESCRIPTION,
PARENT_MASS_ADDITION_ID,
UNREVALUED_COST,
MERGED_CODE,
SPLIT_CODE,
MERGE_PARENT_MASS_ADDITIONS_ID,
SPLIT_PARENT_MASS_ADDITIONS_ID,
PROJECT_ASSET_LINE_ID,
PROJECT_ID,
TASK_ID,
DEPRECIATE_IN_GROUP_FLAG,
MATERIAL_INDICATOR_FLAG,
SOURCE_LINE_ID,
INVOICE_DISTRIBUTION_ID,
INVOICE_LINE_NUMBER,
PO_DISTRIBUTION_ID
FROM FA_ASSET_INVOICES
WHERE ASSET_ID = L_SRC_ASSET_HDR_REC.ASSET_ID
AND INVOICE_TRANSACTION_ID_OUT = L_INV_TRANS_REC.INVOICE_TRANSACTION_ID;
SELECT MCAI.SET_OF_BOOKS_ID,
MCAI.EXCHANGE_RATE,
MCAI.FIXED_ASSETS_COST
FROM FA_MC_ASSET_INVOICES MCAI,
FA_MC_BOOK_CONTROLS MCBK
WHERE MCAI.SOURCE_LINE_ID = P_SOURCE_LINE_ID
AND MCAI.SET_OF_BOOKS_ID = MCBK.SET_OF_BOOKS_ID
AND MCBK.BOOK_TYPE_CODE = L_SRC_ASSET_HDR_REC.BOOK_TYPE_CODE
AND MCBK.ENABLED_FLAG = 'Y';
, lm_trans_rec.who_info.last_update_date
, lm_trans_rec.who_info.last_updated_by
, lm_trans_rec.who_info.last_update_login
, lm_trans_rec.event_id --Added for bug 537059
, l_trx_ref_type; -- bug 5475029
if not fa_xla_events_pvt.update_inter_transaction_event
(p_ledger_id => l_asset_hdr_rec.set_of_books_id,
p_trx_reference_id => lm_trans_rec.trx_reference_id,
p_book_type_code => p_book,
p_event_type_code => l_event_type_code,
p_event_date => l_trans_rec.transaction_date_entered,
p_event_status_code => FA_XLA_EVENTS_PVT.C_EVENT_UNPROCESSED,
p_calling_fn => l_calling_fn,
p_log_level_rec => g_log_level_rec) then
raise group_adj_err;
if not fa_xla_events_pvt.update_transaction_event
(p_ledger_id => l_asset_hdr_rec.set_of_books_id,
p_transaction_header_id => l_thid,
p_book_type_code => p_book,
p_event_type_code => l_event_type_code,
p_event_date => l_trans_rec.transaction_date_entered,
p_event_status_code => FA_XLA_EVENTS_PVT.C_EVENT_UNPROCESSED,
p_calling_fn => l_calling_fn,
p_log_level_rec => g_log_level_rec) then
raise group_adj_err;
p_update_books_summary => TRUE,
p_proceeds_of_sale => 0,
p_cost_of_removal => 0,
x_deprn_exp => l_deprn_exp,
x_bonus_deprn_exp => l_bonus_deprn_exp,
x_impairment_exp => l_impairment_exp,
x_deprn_rsv => l_deprn_rsv, p_log_level_rec => g_log_level_rec)) then
if (g_log_level_rec.statement_level) then
fa_debug_pkg.add('calc_fin_info', 'calling FA_AMORT_PVT.faxama', 'FAILED', p_log_level_rec => g_log_level_rec);
lm_trans_rec.who_info.created_by := l_trans_rec.who_info.last_updated_by;
lm_trans_rec.who_info.creation_date := l_trans_rec.who_info.last_update_date;
update fa_mc_books
set rate_adjustment_factor =
l_asset_fin_rec_new.rate_adjustment_factor,
reval_amortization_basis =
l_asset_fin_rec_new.reval_amortization_basis,
adjusted_cost = l_asset_fin_rec_new.adjusted_cost,
adjusted_capacity = l_asset_fin_rec_new.adjusted_capacity,
eofy_reserve = l_asset_fin_rec_new.eofy_reserve,
adjustment_required_status = 'NONE'
where asset_id = l_asset_id
and book_type_code = p_book
and transaction_header_id_out is null;
update fa_books
set rate_adjustment_factor =
l_asset_fin_rec_new.rate_adjustment_factor,
reval_amortization_basis =
l_asset_fin_rec_new.reval_amortization_basis,
adjusted_cost = l_asset_fin_rec_new.adjusted_cost,
adjusted_capacity = l_asset_fin_rec_new.adjusted_capacity,
eofy_reserve = l_asset_fin_rec_new.eofy_reserve,
adjustment_required_status = 'NONE'
where rowid = l_rowid;
update fa_mc_books
set adjustment_required_status = 'NONE'
where asset_id = l_asset_id
and book_type_code = p_book
and transaction_header_id_out is null;
update fa_books
set adjustment_required_status = 'NONE'
where rowid = l_rowid;
l_dest_inv_tbl(i).DELETED_FLAG,
l_dest_inv_tbl(i).PO_NUMBER,
l_dest_inv_tbl(i).INVOICE_NUMBER,
l_dest_inv_tbl(i).PAYABLES_BATCH_NAME,
l_dest_inv_tbl(i).PAYABLES_CODE_COMBINATION_ID,
l_dest_inv_tbl(i).FEEDER_SYSTEM_NAME,
l_dest_inv_tbl(i).CREATE_BATCH_DATE,
l_dest_inv_tbl(i).CREATE_BATCH_ID,
l_dest_inv_tbl(i).INVOICE_DATE,
l_dest_inv_tbl(i).PAYABLES_COST,
l_dest_inv_tbl(i).POST_BATCH_ID,
l_dest_inv_tbl(i).INVOICE_ID,
l_dest_inv_tbl(i).AP_DISTRIBUTION_LINE_NUMBER,
l_dest_inv_tbl(i).PAYABLES_UNITS,
l_dest_inv_tbl(i).SPLIT_MERGED_CODE,
l_dest_inv_tbl(i).DESCRIPTION,
l_dest_inv_tbl(i).PARENT_MASS_ADDITION_ID,
l_dest_inv_tbl(i).UNREVALUED_COST,
l_dest_inv_tbl(i).MERGED_CODE,
l_dest_inv_tbl(i).SPLIT_CODE,
l_dest_inv_tbl(i).MERGE_PARENT_MASS_ADDITIONS_ID,
l_dest_inv_tbl(i).SPLIT_PARENT_MASS_ADDITIONS_ID,
l_dest_inv_tbl(i).PROJECT_ASSET_LINE_ID,
l_dest_inv_tbl(i).PROJECT_ID,
l_dest_inv_tbl(i).TASK_ID,
l_dest_inv_tbl(i).DEPRECIATE_IN_GROUP_FLAG,
l_dest_inv_tbl(i).MATERIAL_INDICATOR_FLAG,
l_dest_inv_tbl(i).PRIOR_SOURCE_LINE_ID,
l_dest_inv_tbl(i).INVOICE_DISTRIBUTION_ID,
l_dest_inv_tbl(i).INVOICE_LINE_NUMBER,
l_dest_inv_tbl(i).PO_DISTRIBUTION_ID;
select distribution_id,
units_assigned,
code_combination_id,
location_id,
assigned_to
from fa_distribution_history
where asset_id = p_asset_id
and transaction_header_id_out is null;
select transaction_header_id_in
from fa_books
where asset_id = l_asset_id
and book_type_code = p_trx_ref_rec.book_type_code
and transaction_header_id_out = l_trx_id_in;
select transaction_header_id,
transaction_type_code,
transaction_date_entered,
transaction_name,
source_transaction_header_id,
mass_reference_id,
transaction_subtype,
transaction_key,
amortization_start_date,
'FAPGADJ',
mass_transaction_id,
member_transaction_header_id,
trx_reference_id
from fa_transaction_headers
where transaction_header_id = l_trx_id;
select nvl(reserve_transfer_amount, 0)
from fa_trx_references
where dest_asset_id = l_src_asset_hdr_rec.asset_id
and member_asset_id = p_trx_ref_rec.member_asset_id
and book_type_code = p_trx_ref_rec.book_type_code
order by trx_reference_id desc;
update fa_books
set adjustment_required_status = 'NONE'
where asset_id = p_trx_ref_rec.member_asset_id
and book_type_code = p_trx_ref_rec.book_type_code
and adjustment_required_status = 'GADJ'
and transaction_header_id_out is null;
update fa_mc_books
set adjustment_required_status = 'NONE'
where asset_id = p_trx_ref_rec.member_asset_id
and book_type_code = p_trx_ref_rec.book_type_code
and adjustment_required_status = 'GADJ'
and transaction_header_id_out is null;
p_update_books_summary => TRUE,
p_proceeds_of_sale => 0,
p_cost_of_removal => 0,
x_deprn_exp => l_group_reclass_options_rec(l_sob_index).source_exp_amount,
x_bonus_deprn_exp => l_bonus_deprn_exp,
x_impairment_exp => l_impairment_exp,
x_deprn_rsv => l_deprn_rsv, p_log_level_rec => p_log_level_rec)) then
if (p_log_level_rec.statement_level) then
fa_debug_pkg.add(l_calling_fn, 'calling FA_AMORT_PVT.faxama', 'FAILED', p_log_level_rec => p_log_level_rec);
l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
l_rsv_adj.selection_thid := 0;
l_rsv_adj.selection_retid := 0;
l_rsv_adj.last_update_date := l_src_trans_rec.transaction_date_entered;
l_exp_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
l_exp_adj.selection_thid := 0;
l_exp_adj.selection_retid := 0;
l_exp_adj.last_update_date := l_src_trans_rec.transaction_date_entered;
l_src_trans_rec.who_info.last_update_date,
l_src_trans_rec.who_info.last_updated_by,
l_src_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise group_rec_err;
l_src_trans_rec.who_info.last_update_date,
l_src_trans_rec.who_info.last_updated_by,
l_src_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise group_rec_err;
l_src_trans_rec.who_info.last_update_date,
l_src_trans_rec.who_info.last_updated_by,
l_src_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise group_rec_err;
l_src_trans_rec.who_info.last_update_date,
l_src_trans_rec.who_info.last_updated_by,
l_src_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise group_rec_err;
update fa_adjustments
set track_member_flag = null
where transaction_header_id = l_trans_rec.transaction_header_id
and book_type_code = l_asset_hdr_rec.book_type_code;
update fa_mc_adjustments
set track_member_flag = null
where transaction_header_id in
(select transaction_header_id
from fa_transaction_headers th_in
where th_in.asset_id = l_mem_asset_hdr_rec.asset_id
and th_in.book_type_code = l_mem_asset_hdr_rec.book_type_code
and th_in.transaction_type_code = 'TRANSFER'
and th_in.transaction_header_id > l_mem_trans_rec.transaction_header_id);
p_update_books_summary => TRUE,
p_proceeds_of_sale => 0,
p_cost_of_removal => 0,
x_deprn_exp => l_group_reclass_options_rec(l_sob_index).destination_exp_amount,
x_bonus_deprn_exp => l_bonus_deprn_exp,
x_impairment_exp => l_impairment_exp,
x_deprn_rsv => l_deprn_rsv, p_log_level_rec => p_log_level_rec)) then
if (p_log_level_rec.statement_level) then
fa_debug_pkg.add('calc_fin_info', 'calling FA_AMORT_PVT.faxama', 'FAILED', p_log_level_rec => p_log_level_rec);
l_rsv_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
l_rsv_adj.selection_thid := 0;
l_rsv_adj.selection_retid := 0;
l_rsv_adj.last_update_date := l_grp_src_trans_rec(l_sob_index).transaction_date_entered;
l_exp_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
l_exp_adj.selection_thid := 0;
l_exp_adj.selection_retid := 0;
l_exp_adj.last_update_date := l_grp_src_trans_rec(l_sob_index).transaction_date_entered;
l_dest_trans_rec.who_info.last_update_date,
l_dest_trans_rec.who_info.last_updated_by,
l_dest_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise group_rec_err;
l_grp_src_trans_rec(l_sob_index).who_info.last_update_date,
l_grp_src_trans_rec(l_sob_index).who_info.last_updated_by,
l_grp_src_trans_rec(l_sob_index).who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise group_rec_err;
l_dest_trans_rec.who_info.last_update_date,
l_dest_trans_rec.who_info.last_updated_by,
l_dest_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise group_rec_err;
l_grp_src_trans_rec(l_sob_index).who_info.last_update_date,
l_grp_src_trans_rec(l_sob_index).who_info.last_updated_by,
l_grp_src_trans_rec(l_sob_index).who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise group_rec_err;
update fa_books
set adjustment_required_status = 'NONE'
, adjusted_cost = l_grp_src_asset_fin_rec_new(l_sob_index).adjusted_cost
, rate_adjustment_factor = l_grp_src_asset_fin_rec_new(l_sob_index).rate_adjustment_factor
, formula_factor = l_grp_src_asset_fin_rec_new(l_sob_index).formula_factor
, salvage_value = l_grp_src_asset_fin_rec_new(l_sob_index).salvage_value
, allowed_deprn_limit_amount = l_grp_src_asset_fin_rec_new(l_sob_index).allowed_deprn_limit_amount
, recoverable_cost = l_grp_src_asset_fin_rec_new(l_sob_index).recoverable_cost
, adjusted_recoverable_cost = l_grp_src_asset_fin_rec_new(l_sob_index).adjusted_recoverable_cost
, adjusted_capacity = l_grp_src_asset_fin_rec_new(l_sob_index).adjusted_capacity
, reval_amortization_basis = l_grp_src_asset_fin_rec_new(l_sob_index).reval_amortization_basis
, eofy_reserve = l_grp_src_asset_fin_rec_new(l_sob_index).eofy_reserve
where asset_id = l_src_asset
and book_type_code = p_trx_ref_rec.book_type_code
and transaction_header_id_out is null;
update fa_books
set adjustment_required_status = 'NONE'
where asset_id = l_src_asset
and book_type_code = p_trx_ref_rec.book_type_code
and transaction_header_id_out is null;
update fa_books
set adjustment_required_status = 'NONE'
, adjusted_cost = l_grp_dest_asset_fin_rec_new(l_sob_index).adjusted_cost
, rate_adjustment_factor = l_grp_dest_asset_fin_rec_new(l_sob_index).rate_adjustment_factor
, formula_factor = l_grp_dest_asset_fin_rec_new(l_sob_index).formula_factor
, salvage_value = l_grp_dest_asset_fin_rec_new(l_sob_index).salvage_value
, allowed_deprn_limit_amount = l_grp_dest_asset_fin_rec_new(l_sob_index).allowed_deprn_limit_amount
, recoverable_cost = l_grp_dest_asset_fin_rec_new(l_sob_index).recoverable_cost
, adjusted_recoverable_cost = l_grp_dest_asset_fin_rec_new(l_sob_index).adjusted_recoverable_cost
, adjusted_capacity = l_grp_dest_asset_fin_rec_new(l_sob_index).adjusted_capacity
, reval_amortization_basis = l_grp_dest_asset_fin_rec_new(l_sob_index).reval_amortization_basis
, eofy_reserve = l_grp_dest_asset_fin_rec_new(l_sob_index).eofy_reserve
where asset_id = l_dest_asset
and book_type_code = p_trx_ref_rec.book_type_code
and transaction_header_id_out is null;
update fa_books
set adjustment_required_status = 'NONE'
where asset_id = l_dest_asset
and book_type_code = p_trx_ref_rec.book_type_code
and transaction_header_id_out is null;
update fa_trx_references
set reserve_transfer_amount = l_group_reclass_options_rec(l_sob_index).reserve_amount
, src_expense_amount = l_group_reclass_options_rec(l_sob_index).source_exp_amount
, dest_expense_amount = l_group_reclass_options_rec(l_sob_index).destination_exp_amount
where trx_reference_id = l_src_trans_rec.trx_reference_id;
update fa_mc_books
set adjustment_required_status = 'NONE'
, adjusted_cost = l_grp_src_asset_fin_rec_new(l_sob_index).adjusted_cost
, rate_adjustment_factor = l_grp_src_asset_fin_rec_new(l_sob_index).rate_adjustment_factor
, formula_factor = l_grp_src_asset_fin_rec_new(l_sob_index).formula_factor
, salvage_value = l_grp_src_asset_fin_rec_new(l_sob_index).salvage_value
, allowed_deprn_limit_amount = l_grp_src_asset_fin_rec_new(l_sob_index).allowed_deprn_limit_amount
, recoverable_cost = l_grp_src_asset_fin_rec_new(l_sob_index).recoverable_cost
, adjusted_recoverable_cost = l_grp_src_asset_fin_rec_new(l_sob_index).adjusted_recoverable_cost
, adjusted_capacity = l_grp_src_asset_fin_rec_new(l_sob_index).adjusted_capacity
, reval_amortization_basis = l_grp_src_asset_fin_rec_new(l_sob_index).reval_amortization_basis
, eofy_reserve = l_grp_src_asset_fin_rec_new(l_sob_index).eofy_reserve
where asset_id = l_src_asset
and book_type_code = p_trx_ref_rec.book_type_code
and transaction_header_id_out is null
and set_of_books_id = l_sob_tbl(l_sob_index);
update fa_mc_books
set adjustment_required_status = 'NONE'
where asset_id = l_src_asset
and book_type_code = p_trx_ref_rec.book_type_code
and transaction_header_id_out is null
and set_of_books_id = l_sob_tbl(l_sob_index);
update fa_mc_books
set adjustment_required_status = 'NONE'
, adjusted_cost = l_grp_dest_asset_fin_rec_new(l_sob_index).adjusted_cost
, rate_adjustment_factor = l_grp_dest_asset_fin_rec_new(l_sob_index).rate_adjustment_factor
, formula_factor = l_grp_dest_asset_fin_rec_new(l_sob_index).formula_factor
, salvage_value = l_grp_dest_asset_fin_rec_new(l_sob_index).salvage_value
, allowed_deprn_limit_amount = l_grp_dest_asset_fin_rec_new(l_sob_index).allowed_deprn_limit_amount
, recoverable_cost = l_grp_dest_asset_fin_rec_new(l_sob_index).recoverable_cost
, adjusted_recoverable_cost = l_grp_dest_asset_fin_rec_new(l_sob_index).adjusted_recoverable_cost
, adjusted_capacity = l_grp_dest_asset_fin_rec_new(l_sob_index).adjusted_capacity
, reval_amortization_basis = l_grp_dest_asset_fin_rec_new(l_sob_index).reval_amortization_basis
, eofy_reserve = l_grp_dest_asset_fin_rec_new(l_sob_index).eofy_reserve
where asset_id = l_dest_asset
and book_type_code = p_trx_ref_rec.book_type_code
and transaction_header_id_out is null
and set_of_books_id = l_sob_tbl(l_sob_index);
update fa_mc_books
set adjustment_required_status = 'NONE'
where asset_id = l_dest_asset
and book_type_code = p_trx_ref_rec.book_type_code
and transaction_header_id_out is null
and set_of_books_id = l_sob_tbl(l_sob_index);