The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT bk.asset_id asset_id
, ad.asset_category_id category_id
, bk.deprn_method_code deprn_method_code
, nvl(bk.life_in_months, 0) life_in_months
, bk.rate_adjustment_factor rate_adjustment_factor
, ad.current_units current_units
, bk.adjustment_required_status adjustment_required_status
, bk.cost_change_flag cost_change_flag
, bk.retirement_pending_flag retirement_pending_flag
, bk.period_counter_fully_retired period_counter_fully_retired
, ad.asset_number asset_number
, bk.adjusted_cost adjusted_cost
, nvl(bk.adjusted_rate, 0) adjusted_rate
, bk.recoverable_cost recoverable_cost
, nvl(bk.reval_amortization_basis, 0) reval_amortization_basis
, bk.ceiling_name ceiling_name
, bk.bonus_rule bonus_rule
, bk.deprn_start_date deprn_start_date
, bk.date_placed_in_service date_placed_in_service
, bk.prorate_date prorate_date
, bk.cost cost
, bk.production_capacity production_capacity
, bk.adjusted_capacity adjusted_capacity
, bk.annual_deprn_rounding_flag annual_deprn_rounding_flag
, bk.salvage_value salvage_value
, bk.period_counter_life_complete period_counter_life_complete
, bk.adjusted_recoverable_cost adjusted_recoverable_cost
, nvl(bk.short_fiscal_year_flag, 'NO') short_fiscal_year_flag
, bk.conversion_date conversion_date
, bk.original_deprn_start_date original_deprn_start_date
, nvl(bk.formula_factor, 1) formula_factor
, nvl(bk.old_adjusted_cost, 1) old_adjusted_cost
, bk.tracking_method tracking_method
, bk.allocate_to_fully_ret_flag allocate_to_fully_ret_flag
, bk.allocate_to_fully_rsv_flag allocate_to_fully_rsv_flag
, bk.excess_allocation_option excess_allocation_option
, bk.depreciation_option depreciation_option
, bk.member_rollup_flag member_rollup_flag
, ad.asset_type asset_type
, bk.group_asset_id group_asset_id
, nvl(bk.eofy_reserve, 0) eofy_reserve
, bk.exclude_fully_rsv_flag exclude_fully_rsv_flag
, 0 over_depreciate_option -- over_depreciate_option
, 0 terminal_gain_loss --terminal gain loss
, 0 terminal_gain_loss_flag --terminal gain loss flag
, 0 super_group_id -- super_group_id
, 0 super_group_pct_sal_value --super grp pct salvage value
, 0 net_book_value -- net_book_value
, 0 net_selling_price -- net_selling_price
, 0 value_in_use -- value_in_use
, imp.ytd_impairment -- ytd_impairment
, imp.impairment_reserve -- impairment_reserve
, sysdate deprn_run_date -- deprn_run_date
, 0 deprn_amount -- deprn_amount
, 0 ytd_deprn -- ytd_deprn
, 0 deprn_reserve -- deprn_reserve
, 'DEPRN' deprn_source_code -- deprn_source_code
, 0 bonus_rate -- bonus_rate
, 0 ltd_production -- ltd_production
, 0 production -- production
, 0 reval_amortization -- reval_amortization
, 0 reval_deprn_expense -- reval_deprn_expense
, 0 reval_reserve -- reval_reserve
, 0 ytd_production -- ytd_production
, 0 ytd_reval_deprn_expense -- ytd_reval_deprn_expense
, 0 prior_fy_expense -- prior_fy_expense
, 0 bonus_deprn_amount -- bonus_deprn_amount
, 0 bonus_ytd_deprn -- bonus_ytd_deprn
, 0 bonus_deprn_reserve -- bonus_deprn_reserve
, 0 prior_fy_bonus_expense -- prior_fy_bonus_expense
, 0 deprn_override_flag -- deprn_override_flag
, 0 system_deprn_amount -- system_deprn_amount
, 0 system_bonus_deprn_amount -- system_bonus_deprn_amount
, 0 deprn_adjustment_amount -- deprn_adjustment_amount
, 0 bonus_deprn_adjustment_amount -- bonus_deprn_adjustment_amount
, imp.rowid imp_rowid
, 'N' Period_of_addition_flag -- Period_of_addition_flag
, imp.impairment_id -- impairment_id
, 0 capital_adjustment -- Bug 6666666 : Capital Adjustment amount
, 0 general_fund -- Bug 6666666 : General Fund Balance Amount
, bk.ALLOWED_DEPRN_LIMIT_AMOUNT
, bk.depreciate_flag --phase5
, bk.period_counter_fully_reserved --phase5
, 0 reval_loss_balance
FROM fa_additions_b ad,
fa_methods mt,
fa_books bk,
fa_itf_impairments imp
WHERE bk.book_type_code = p_book_type_code
AND (bk.period_counter_fully_retired is null OR
bk.adjustment_required_status <> 'NONE')
--phase5 AND bk.depreciate_flag = 'YES'
AND bk.date_effective <= nvl(p_period_rec.period_close_date, sysdate)
AND bk.transaction_header_id_out is null
AND AD.ASSET_ID=BK.ASSET_ID
AND ad.asset_type = 'CAPITALIZED'
AND bk.group_asset_id is null
AND MT.METHOD_CODE = BK.DEPRN_METHOD_CODE
AND nvl(mt.life_in_months, -99) = nvl(bk.life_in_months, -99)
AND bk.deprn_start_date <= p_period_rec.calendar_period_close_date
AND bk.asset_id = imp.asset_id
AND imp.book_type_code = p_book_type_code
AND imp.request_id = p_request_id
AND imp.period_counter <= p_period_rec.period_counter
AND imp.worker_id = p_worker_id;
SELECT bk.asset_id asset_id
, ad.asset_category_id category_id
, bk.deprn_method_code deprn_method_code
, nvl(bk.life_in_months, 0) life_in_months
, bk.rate_adjustment_factor rate_adjustment_factor
, ad.current_units current_units
, bk.adjustment_required_status adjustment_required_status
, bk.cost_change_flag cost_change_flag
, bk.retirement_pending_flag retirement_pending_flag
, bk.period_counter_fully_retired period_counter_fully_retired
, ad.asset_number asset_number
, bk.adjusted_cost adjusted_cost
, nvl(bk.adjusted_rate, 0) adjusted_rate
, bk.recoverable_cost recoverable_cost
, nvl(bk.reval_amortization_basis, 0) reval_amortization_basis
, bk.ceiling_name ceiling_name
, bk.bonus_rule bonus_rule
, bk.deprn_start_date deprn_start_date
, bk.date_placed_in_service date_placed_in_service
, bk.prorate_date prorate_date
, bk.cost cost
, bk.production_capacity production_capacity
, bk.adjusted_capacity adjusted_capacity
, bk.annual_deprn_rounding_flag annual_deprn_rounding_flag
, bk.salvage_value salvage_value
, bk.period_counter_life_complete period_counter_life_complete
, bk.adjusted_recoverable_cost adjusted_recoverable_cost
, nvl(bk.short_fiscal_year_flag, 'NO') short_fiscal_year_flag
, bk.conversion_date conversion_date
, bk.original_deprn_start_date original_deprn_start_date
, nvl(bk.formula_factor, 1) formula_factor
, nvl(bk.old_adjusted_cost, 1) old_adjusted_cost
, bk.tracking_method tracking_method
, bk.allocate_to_fully_ret_flag allocate_to_fully_ret_flag
, bk.allocate_to_fully_rsv_flag allocate_to_fully_rsv_flag
, bk.excess_allocation_option excess_allocation_option
, bk.depreciation_option depreciation_option
, bk.member_rollup_flag member_rollup_flag
, ad.asset_type asset_type
, bk.group_asset_id group_asset_id
, nvl(bk.eofy_reserve, 0) eofy_reserve
, bk.exclude_fully_rsv_flag exclude_fully_rsv_flag
, 0 over_depreciate_option -- over_depreciate_option
, 0 terminal_gain_loss --terminal gain loss
, 0 terminal_gain_loss_flag --terminal gain loss flag
, 0 super_group_id -- super_group_id
, 0 super_group_pct_sal_value --super grp pct salvage value
, 0 net_book_value -- net_book_value
, 0 net_selling_price -- net_selling_price
, 0 value_in_use -- value_in_use
, imp.ytd_impairment -- ytd_impairment
, imp.impairment_reserve -- impairment_reserve
, sysdate deprn_run_date -- deprn_run_date
, 0 deprn_amount -- deprn_amount
, 0 ytd_deprn -- ytd_deprn
, 0 deprn_reserve -- deprn_reserve
, 'DEPRN' deprn_source_code -- deprn_source_code
, 0 bonus_rate -- bonus_rate
, 0 ltd_production -- ltd_production
, 0 production -- production
, 0 reval_amortization -- reval_amortization
, 0 reval_deprn_expense -- reval_deprn_expense
, 0 reval_reserve -- reval_reserve
, 0 ytd_production -- ytd_production
, 0 ytd_reval_deprn_expense -- ytd_reval_deprn_expense
, 0 prior_fy_expense -- prior_fy_expense
, 0 bonus_deprn_amount -- bonus_deprn_amount
, 0 bonus_ytd_deprn -- bonus_ytd_deprn
, 0 bonus_deprn_reserve -- bonus_deprn_reserve
, 0 prior_fy_bonus_expense -- prior_fy_bonus_expense
, 0 deprn_override_flag -- deprn_override_flag
, 0 system_deprn_amount -- system_deprn_amount
, 0 system_bonus_deprn_amount -- system_bonus_deprn_amount
, 0 deprn_adjustment_amount -- deprn_adjustment_amount
, 0 bonus_deprn_adjustment_amount -- bonus_deprn_adjustment_amount
, imp.rowid imp_rowid
, 'N' Period_of_addition_flag -- Period_of_addition_flag
, imp.impairment_id -- impairment_id
, 0 capital_adjustment -- Bug 6666666 : Capital Adjustment amount
, 0 general_fund -- Bug 6666666 : General Fund Balance Amount
, bk.ALLOWED_DEPRN_LIMIT_AMOUNT
, bk.depreciate_flag --phase5
, bk.period_counter_fully_reserved --phase5
, 0 reval_loss_balance
FROM fa_additions_b ad,
fa_methods mt,
fa_mc_books bk,
fa_mc_itf_impairments imp
WHERE bk.book_type_code = p_book_type_code
AND bk.set_of_books_id = p_set_of_books_id
AND (bk.period_counter_fully_retired is null OR
bk.adjustment_required_status <> 'NONE')
--phase5 AND bk.depreciate_flag = 'YES'
AND bk.date_effective <= nvl(p_period_rec.period_close_date, sysdate)
AND bk.transaction_header_id_out is null
AND AD.ASSET_ID=BK.ASSET_ID
AND ad.asset_type = 'CAPITALIZED'
AND bk.group_asset_id is null
AND MT.METHOD_CODE = BK.DEPRN_METHOD_CODE
AND nvl(mt.life_in_months, -99) = nvl(bk.life_in_months, -99)
AND bk.deprn_start_date <= p_period_rec.calendar_period_close_date
AND bk.asset_id = imp.asset_id
AND imp.book_type_code = p_book_type_code
AND imp.request_id = p_request_id
AND imp.period_counter <= p_period_rec.period_counter
AND imp.worker_id = p_worker_id
AND imp.set_of_books_id = p_set_of_books_id;
select cp.period_num
, fy.fiscal_year
from fa_fiscal_year fy
, fa_calendar_periods cp
where cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
and cp.start_date between fy.start_date and fy.end_date
and c_start_date between cp.start_date and cp.end_date;
g_error_flag.DELETE ; --Bug#8614268
l_dpr_in.update_override_status := TRUE;
l_pa_dpr_arr.delete;
UPDATE FA_MC_ITF_IMPAIRMENTS
SET NET_BOOK_VALUE = t_net_book_value(i)
, YTD_IMPAIRMENT = t_ytd_impairment(i)
, impairment_reserve = t_impairment_reserve(i)
, DEPRN_RUN_DATE = t_deprn_run_date(i)
, DEPRN_AMOUNT = t_deprn_amount(i)
, YTD_DEPRN = t_ytd_deprn(i)
, DEPRN_RESERVE = t_deprn_reserve(i)
, ADJUSTED_COST = t_adjusted_cost(i)
, BONUS_RATE = t_bonus_rate(i)
, LTD_PRODUCTION = t_ltd_production(i)
, PRODUCTION = t_production(i)
, REVAL_AMORTIZATION = t_reval_amortization(i)
, REVAL_AMORTIZATION_BASIS = t_reval_amortization_basis(i)
, REVAL_DEPRN_EXPENSE = t_reval_deprn_expense(i)
, REVAL_RESERVE = t_reval_reserve(i)
, YTD_PRODUCTION = t_ytd_production(i)
, YTD_REVAL_DEPRN_EXPENSE = t_ytd_reval_deprn_expense(i)
, PRIOR_FY_EXPENSE = t_prior_fy_expense(i)
, BONUS_DEPRN_AMOUNT = t_bonus_deprn_amount(i)
, BONUS_YTD_DEPRN = t_bonus_ytd_deprn(i)
, BONUS_DEPRN_RESERVE = t_bonus_deprn_reserve(i)
, PRIOR_FY_BONUS_EXPENSE = t_prior_fy_bonus_expense(i)
, DEPRN_OVERRIDE_FLAG = t_deprn_override_flag(i)
, SYSTEM_DEPRN_AMOUNT = t_system_deprn_amount(i)
, SYSTEM_BONUS_DEPRN_AMOUNT = t_system_bonus_deprn_amount(i)
, DEPRN_ADJUSTMENT_AMOUNT = t_deprn_adjustment_amount(i)
, BONUS_DEPRN_ADJUSTMENT_AMOUNT = t_bonus_deprn_adj_amount(i)
, CURRENT_UNITS = t_current_units(i)
, CATEGORY_ID = t_category_id(i)
, PERIOD_OF_ADDITION_FLAG = t_period_of_addition_flag(i)
, EOFY_RESERVE = t_eofy_reserve(i)
, CAPITAL_ADJUSTMENT = t_capital_adjustment(i) -- Bug 6666666
, GENERAL_FUND = t_general_fund(i) -- Bug 6666666
, ALLOWED_DEPRN_LIMIT_AMOUNT = t_allowed_deprn_limit_amount(i)
, REVAL_LOSS_BALANCE = t_reval_loss_balance(i)
WHERE ROWID = t_imp_rowid(i);
UPDATE FA_ITF_IMPAIRMENTS
SET NET_BOOK_VALUE = t_net_book_value(i)
, YTD_IMPAIRMENT = t_ytd_impairment(i)
, impairment_reserve = t_impairment_reserve(i)
, DEPRN_RUN_DATE = t_deprn_run_date(i)
, DEPRN_AMOUNT = t_deprn_amount(i)
, YTD_DEPRN = t_ytd_deprn(i)
, DEPRN_RESERVE = t_deprn_reserve(i)
, ADJUSTED_COST = t_adjusted_cost(i)
, BONUS_RATE = t_bonus_rate(i)
, LTD_PRODUCTION = t_ltd_production(i)
, PRODUCTION = t_production(i)
, REVAL_AMORTIZATION = t_reval_amortization(i)
, REVAL_AMORTIZATION_BASIS = t_reval_amortization_basis(i)
, REVAL_DEPRN_EXPENSE = t_reval_deprn_expense(i)
, REVAL_RESERVE = t_reval_reserve(i)
, YTD_PRODUCTION = t_ytd_production(i)
, YTD_REVAL_DEPRN_EXPENSE = t_ytd_reval_deprn_expense(i)
, PRIOR_FY_EXPENSE = t_prior_fy_expense(i)
, BONUS_DEPRN_AMOUNT = t_bonus_deprn_amount(i)
, BONUS_YTD_DEPRN = t_bonus_ytd_deprn(i)
, BONUS_DEPRN_RESERVE = t_bonus_deprn_reserve(i)
, PRIOR_FY_BONUS_EXPENSE = t_prior_fy_bonus_expense(i)
, DEPRN_OVERRIDE_FLAG = t_deprn_override_flag(i)
, SYSTEM_DEPRN_AMOUNT = t_system_deprn_amount(i)
, SYSTEM_BONUS_DEPRN_AMOUNT = t_system_bonus_deprn_amount(i)
, DEPRN_ADJUSTMENT_AMOUNT = t_deprn_adjustment_amount(i)
, BONUS_DEPRN_ADJUSTMENT_AMOUNT = t_bonus_deprn_adj_amount(i)
, CURRENT_UNITS = t_current_units(i)
, CATEGORY_ID = t_category_id(i)
, PERIOD_OF_ADDITION_FLAG = t_period_of_addition_flag(i)
, EOFY_RESERVE = t_eofy_reserve(i)
, CAPITAL_ADJUSTMENT = t_capital_adjustment(i) -- Bug 6666666
, GENERAL_FUND = t_general_fund(i) -- Bug 6666666
, ALLOWED_DEPRN_LIMIT_AMOUNT = t_allowed_deprn_limit_amount(i)
, REVAL_LOSS_BALANCE = t_reval_loss_balance(i)
WHERE ROWID = t_imp_rowid(i);
SELECT curr.precision
FROM fnd_currencies curr
, gl_sets_of_books sob
WHERE sob.set_of_books_id = c_set_of_books_id
AND curr.currency_code = sob.currency_code;
select imp.rowid
, imp.impairment_id
, imp.cash_generating_unit_id
, greatest(nvl(imp.net_selling_price, 0),nvl(imp.value_in_use, 0))
, ROUND(imp.impairment_amount,l_precision)
, nvl(sum(itf.net_book_value),0)
, imp.asset_id -- Bug# 7000391
, nvl(books.sorp_enabled_flag, 'N') -- Bug 6666666
, imp.net_selling_price --Bug# 7511258
, imp.value_in_use --Bug# 7511258
from fa_impairments imp
, fa_itf_impairments itf
, fa_book_controls books
where imp.request_id = p_request_id
and imp.book_type_code = p_book_type_code
and imp.impairment_id = itf.impairment_id
and nvl(itf.goodwill_asset_flag, 'N') <> 'Y'
and imp.period_counter_impaired = p_period_rec.period_counter
and books.book_type_code = p_book_type_code
group by imp.rowid
, imp.impairment_id
, imp.cash_generating_unit_id
, greatest(nvl(imp.net_selling_price, 0),nvl(imp.value_in_use, 0))
, imp.impairment_amount
, imp.asset_id -- Bug# 7000391
, nvl(books.sorp_enabled_flag, 'N') -- Bug 6666666
, imp.net_selling_price --Bug# 7511258
, imp.value_in_use ; --Bug# 7511258
select imp.rowid
, imp.impairment_id
, imp.cash_generating_unit_id
, greatest(nvl(imp.net_selling_price, 0),nvl(imp.value_in_use, 0))
, nvl(imp.impairment_amount, 0)
, nvl(sum(itf.net_book_value),0)
, imp.asset_id -- Bug# 7000391
, nvl(books.sorp_enabled_flag, 'N') -- Bug 6666666
, imp.net_selling_price --Bug# 7511258
, imp.value_in_use --Bug# 7511258
from fa_mc_impairments imp
, fa_mc_itf_impairments itf
, fa_book_controls books
where imp.request_id = p_request_id
and imp.book_type_code = p_book_type_code
and imp.impairment_id = itf.impairment_id
and nvl(itf.goodwill_asset_flag, 'N') <> 'Y'
and imp.period_counter_impaired = p_period_rec.period_counter
and books.book_type_code = p_book_type_code --8666930
and imp.set_of_books_id = p_set_of_books_id
and itf.set_of_books_id = p_set_of_books_id
group by imp.rowid
, imp.impairment_id
, imp.cash_generating_unit_id
, greatest(nvl(imp.net_selling_price, 0),nvl(imp.value_in_use, 0))
, imp.impairment_amount
, imp.asset_id -- Bug# 7000391
, nvl(books.sorp_enabled_flag, 'N') -- Bug 6666666
, imp.net_selling_price --Bug# 7511258
, imp.value_in_use; --Bug# 7511258
select sum(impairment_amount)
from fa_itf_impairments
where impairment_id = c_impairment_id
and nvl(goodwill_asset_flag, 'N') <> 'Y';
select sum(impairment_amount)
from fa_mc_itf_impairments
where impairment_id = c_impairment_id
and nvl(goodwill_asset_flag, 'N') <> 'Y'
and set_of_books_id = p_set_of_books_id;
select rowid
, net_book_value
, impairment_amount
, ytd_impairment
, impairment_reserve
from fa_itf_impairments
where impairment_id = c_impairment_id
and net_book_value <> 0
and nvl(goodwill_asset_flag, 'N') <> 'Y';
select rowid
, net_book_value
, impairment_amount
, ytd_impairment
, impairment_reserve
from fa_mc_itf_impairments
where impairment_id = c_impairment_id
and net_book_value <> 0
and nvl(goodwill_asset_flag, 'N') <> 'Y'
and set_of_books_id = p_set_of_books_id;
select impairment_id
from fa_itf_impairments
where request_id = p_request_id
and (asset_id = c_asset_id or cash_generating_unit_id = c_cgu_id) order by impairment_id;
select impairment_id
from fa_mc_itf_impairments
where request_id = p_request_id
and (asset_id = c_asset_id or cash_generating_unit_id = c_cgu_id)
and set_of_books_id = p_set_of_books_id
order by impairment_id;
select 'POSTED'
from fa_mc_impairments
where status = 'POSTED'
and ((asset_id = c_asset_id or cash_generating_unit_id = c_cgu_id) or
(asset_id in (select asset_id from fa_books fbs
where fbs.book_type_code = p_book_type_code
and fbs.transaction_header_id_out is null
and fbs.cash_generating_unit_id = c_cgu_id)) or
(cash_generating_unit_id = (select cash_generating_unit_id from fa_books fbs
where fbs.book_type_code = p_book_type_code
and fbs.transaction_header_id_out is null
and fbs.asset_id = c_asset_id)))
and book_type_code = p_book_type_code /*Bug# 8263733 - Added filter condition with book_type_code */
AND PERIOD_COUNTER_IMPAIRED = p_period_rec.period_counter
AND set_of_books_id = p_set_of_books_id;
select 'POSTED'
from fa_impairments
where status = 'POSTED'
and ((asset_id = c_asset_id or cash_generating_unit_id = c_cgu_id) or
(asset_id in (select asset_id from fa_books fbs
where fbs.book_type_code = p_book_type_code
and fbs.transaction_header_id_out is null
and fbs.cash_generating_unit_id = c_cgu_id)) or
(cash_generating_unit_id = (select cash_generating_unit_id from fa_books fbs
where fbs.book_type_code = p_book_type_code
and fbs.transaction_header_id_out is null
and fbs.asset_id = c_asset_id)))
and book_type_code = p_book_type_code /*Bug# 8263733 - Added filter condition with book_type_code */
AND PERIOD_COUNTER_IMPAIRED = p_period_rec.period_counter;
UPDATE FA_MC_IMPAIRMENTS IMP
SET NET_BOOK_VALUE = t_net_book_value(i)
, IMPAIRMENT_AMOUNT = round(decode(nvl(t2_impairment_amount(i), 0), 0,
t_net_book_value(i) - t_fair_market_value(i), t2_impairment_amount(i)),l_precision)
, IMPAIRMENT_DATE = nvl(IMPAIRMENT_DATE, p_transaction_date)
, NET_SELLING_PRICE = round(t_net_selling_price(i),l_precision)
, VALUE_IN_USE = round(t_value_in_use(i),l_precision)
WHERE ROWID = t_rowid(i)
RETURNING IMPAIRMENT_AMOUNT BULK COLLECT INTO t_impairment_amount;
UPDATE FA_IMPAIRMENTS IMP
SET NET_BOOK_VALUE = t_net_book_value(i)
, IMPAIRMENT_AMOUNT = round(decode(nvl(t2_impairment_amount(i), 0), 0,
t_net_book_value(i) - t_fair_market_value(i), t2_impairment_amount(i)),l_precision)
, IMPAIRMENT_DATE = nvl(IMPAIRMENT_DATE, p_transaction_date)
, NET_SELLING_PRICE = round(t_net_selling_price(i),l_precision)
, VALUE_IN_USE = round(t_value_in_use(i),l_precision)
WHERE ROWID = t_rowid(i)
RETURNING IMPAIRMENT_AMOUNT BULK COLLECT INTO t_impairment_amount;
UPDATE FA_MC_ITF_IMPAIRMENTS ITF
SET IMPAIRMENT_AMOUNT = least(round(t_impairment_amount(i) *
(NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
NET_BOOK_VALUE)
, YTD_IMPAIRMENT = YTD_IMPAIRMENT + least(round(t_impairment_amount(i) *
(NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
NET_BOOK_VALUE)
, impairment_reserve = impairment_reserve + least(round(t_impairment_amount(i) *
(NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
NET_BOOK_VALUE)
, NET_SELLING_PRICE = least(round(t_net_selling_price(i) *
(NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
NET_BOOK_VALUE) --Bug# 7511258,9182681
, VALUE_IN_USE = least(round(t_value_in_use(i) *
(NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
NET_BOOK_VALUE) --Bug# 7511258,9182681
WHERE IMPAIRMENT_ID = t_impairment_id(i)
AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
AND t_net_book_value(i) <> 0
AND set_of_books_id = p_set_of_books_id; -- Bug# 6920854
UPDATE FA_MC_ITF_IMPAIRMENTS ITF
SET NET_BOOK_VALUE = COST - DEPRN_RESERVE - impairment_reserve
WHERE IMPAIRMENT_ID = t_impairment_id(i)
AND GOODWILL_ASSET_FLAG = 'Y'
AND set_of_books_id = p_set_of_books_id;
UPDATE FA_ITF_IMPAIRMENTS ITF
SET IMPAIRMENT_AMOUNT = least(round(t_impairment_amount(i) *
(NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
NET_BOOK_VALUE)
, YTD_IMPAIRMENT = YTD_IMPAIRMENT + least(round(t_impairment_amount(i) *
(NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
NET_BOOK_VALUE)
, impairment_reserve = impairment_reserve + least(round(t_impairment_amount(i) *
(NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
NET_BOOK_VALUE)
, NET_SELLING_PRICE = least(round(t_net_selling_price(i) *
(NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
NET_BOOK_VALUE) --Bug# 7511258,9182681
, VALUE_IN_USE = least(round(t_value_in_use(i) *
(NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
NET_BOOK_VALUE) --Bug# 7511258,9182681
WHERE IMPAIRMENT_ID = t_impairment_id(i)
AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
AND t_net_book_value(i) <> 0; -- Bug# 6920854
UPDATE FA_ITF_IMPAIRMENTS ITF
SET NET_BOOK_VALUE = COST - DEPRN_RESERVE - impairment_reserve
WHERE IMPAIRMENT_ID = t_impairment_id(i)
AND GOODWILL_ASSET_FLAG = 'Y';
ti_rowid.delete;
ti_net_book_value.delete;
ti_impairment_amount.delete;
ti_ytd_impairment.delete;
ti_impairment_reserve.delete;
UPDATE FA_MC_ITF_IMPAIRMENTS
SET IMPAIRMENT_AMOUNT = ti_impairment_amount(j)
, YTD_IMPAIRMENT = ti_ytd_impairment(j)
, impairment_reserve = ti_impairment_reserve(j)
, NET_BOOK_VALUE = ti_net_book_value(j)
WHERE ROWID = ti_rowid(j);
UPDATE FA_ITF_IMPAIRMENTS
SET IMPAIRMENT_AMOUNT = ti_impairment_amount(j)
, YTD_IMPAIRMENT = ti_ytd_impairment(j)
, impairment_reserve = ti_impairment_reserve(j)
, NET_BOOK_VALUE = ti_net_book_value(j)
WHERE ROWID = ti_rowid(j);
UPDATE FA_MC_ITF_IMPAIRMENTS ITF
SET IMPAIRMENT_AMOUNT = IMPAIRMENT_AMOUNT - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
, YTD_IMPAIRMENT = YTD_IMPAIRMENT - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
, REVAL_RESERVE = REVAL_RESERVE - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
, REVAL_RESERVE_ADJ_AMOUNT = least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
WHERE IMPAIRMENT_ID = t_impairment_id(i)
AND nvl(REVAL_RESERVE, 0) <> 0
AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
AND t_sorp_enabled_flag(i) <> 'Y'
AND set_of_books_id = p_set_of_books_id; -- Bug 6666666
UPDATE FA_ITF_IMPAIRMENTS ITF
SET IMPAIRMENT_AMOUNT = IMPAIRMENT_AMOUNT - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
, YTD_IMPAIRMENT = YTD_IMPAIRMENT - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
, REVAL_RESERVE = REVAL_RESERVE - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
, REVAL_RESERVE_ADJ_AMOUNT = least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
WHERE IMPAIRMENT_ID = t_impairment_id(i)
AND nvl(REVAL_RESERVE, 0) <> 0
AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
AND t_sorp_enabled_flag(i) <> 'Y'; -- Bug 6666666;
UPDATE FA_MC_IMPAIRMENTS IMP
SET NET_BOOK_VALUE = t_net_book_value(i)
WHERE ROWID = t_rowid(i);
UPDATE FA_IMPAIRMENTS IMP
SET NET_BOOK_VALUE = t_net_book_value(i)
WHERE ROWID = t_rowid(i);
UPDATE FA_MC_ITF_IMPAIRMENTS ITF
SET DEPRN_RESERVE = DEPRN_RESERVE + (nvl(impairment_reserve,0) - NET_BOOK_VALUE),
IMPAIRMENT_AMOUNT = t_impairment_amount(i),
impairment_reserve = t_impairment_amount(i),
NET_BOOK_VALUE = t_net_book_value(i)
WHERE IMPAIRMENT_ID = t_impairment_id(i)
AND p_nbv(i) =0
AND set_of_books_id = p_set_of_books_id;
UPDATE FA_MC_ITF_IMPAIRMENTS ITF
SET PERIOD_OF_ADDITION_FLAG = 'F'
WHERE IMPAIRMENT_ID = t_impairment_id(i)
AND p_nbv(i) in (-1,-2,-3,-4)
AND set_of_books_id = p_set_of_books_id; --Bug#7594562 Added -2
UPDATE FA_ITF_IMPAIRMENTS ITF
SET DEPRN_RESERVE = DEPRN_RESERVE + (nvl(impairment_reserve,0) - NET_BOOK_VALUE),
IMPAIRMENT_AMOUNT = t_impairment_amount(i),
impairment_reserve = t_impairment_amount(i),
NET_BOOK_VALUE = t_net_book_value(i)
WHERE IMPAIRMENT_ID = t_impairment_id(i)
AND p_nbv(i) =0;
UPDATE FA_ITF_IMPAIRMENTS ITF
SET PERIOD_OF_ADDITION_FLAG = 'F'
WHERE IMPAIRMENT_ID = t_impairment_id(i)
AND p_nbv(i) in (-1,-2,-3,-4) ; --Bug#7594562 Added -2
select th.transaction_header_id
, th.transaction_type_code
, th.transaction_subtype
, th.transaction_key
, (fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM +
decode(th.transaction_key, 'IM', 1, 0)) period_counter
, (inbk.cost - nvl(outbk.cost, 0))
, (nvl(inbk.cip_cost, 0) - nvl(outbk.cip_cost, 0))
-- , (decode(inbk.salvage_type,
-- outbk.salvage_type,
-- inbk.salvage_value - nvl(outbk.salvage_value, 0),
-- inbk.salvage_value))
, inbk.salvage_value - nvl(outbk.salvage_value, 0)
-- , (decode(inbk.deprn_limit_type,
-- outbk.deprn_limit_type,
-- nvl(decode(inbk.deprn_limit_type, 'NONE', inbk.salvage_value,
-- inbk.allowed_deprn_limit_amount), 0) -
-- nvl(decode(outbk.deprn_limit_type, 'NONE', outbk.salvage_value,
-- outbk.allowed_deprn_limit_amount), 0),
-- nvl(decode(inbk.deprn_limit_type, 'NONE', inbk.salvage_value,
-- inbk.allowed_deprn_limit_amount), 0)))
, nvl(inbk.allowed_deprn_limit_amount, 0) - nvl(outbk.allowed_deprn_limit_amount, 0)
, inbk.salvage_type
, nvl(outbk.salvage_type, inbk.salvage_type)
, inbk.percent_salvage_value
, nvl(outbk.percent_salvage_value, 0)
, inbk.deprn_limit_type
, nvl(outbk.deprn_limit_type, inbk.deprn_limit_type)
, inbk.allowed_deprn_limit
, nvl(outbk.allowed_deprn_limit, null)
, inbk.deprn_method_code
, inbk.life_in_months
, inbk.adjusted_rate
, inbk.production_capacity
from fa_transaction_headers th
, fa_books inbk
, fa_books outbk
, fa_calendar_types ct
, fa_calendar_periods cp
, fa_fiscal_year fy
where th.asset_id = p_asset_id
and th.book_type_code = p_book_type_code
and inbk.asset_id = th.asset_id
and inbk.asset_id = outbk.asset_id(+)
and inbk.book_type_code = outbk.book_type_code(+)
and inbk.transaction_header_id_in = th.transaction_header_id
and inbk.transaction_header_id_in = outbk.transaction_header_id_out(+)
and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
and ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
and cp.calendar_type = ct.calendar_type
and cp.start_date between fy.start_date and fy.end_date
and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
and (
(
th.transaction_type_code not in ('TRANSFER OUT', 'TRANSFER IN',
'TRANSFER', 'TRANSFER IN/VOID',
'RECLASS', 'UNIT ADJUSTMENT',
'REINSTATEMENT', 'ADDITION/VOID',
'ADDITION', 'CIP ADDITION',
'CIP ADJUSTMENT', 'CIP ADDITION/VOID')
and decode(th.transaction_subtype,
'EXPENSED', p_date_placed_in_service,
greatest(nvl(th.amortization_start_date,
th.transaction_date_entered), p_date_placed_in_service))
between cp.start_date
and cp.end_date
)
or
(
th.transaction_type_code = 'ADDITION'
and (
(
exists (select 1 from fa_deprn_summary ds
where ds.deprn_reserve <> 0
and ds.book_type_code = p_book_type_code
and ds.asset_id = p_asset_id
and ds.deprn_source_code = 'BOOKS')
and decode(th.transaction_subtype,
'AMORTIZED', th.amortization_start_date,
(select dp.calendar_period_open_date
from fa_deprn_periods dp
where dp.book_type_code = p_book_type_code
and th.date_effective
between period_open_date
and nvl(period_close_date, sysdate)))
between cp.start_date
and cp.end_date
)
or
(
greatest(nvl(th.amortization_start_date,
th.transaction_date_entered), p_date_placed_in_service)
--to_date('01-JAN-1996', 'DD-MON-YYYY')
between cp.start_date
and cp.end_date
and exists (select 1 from fa_deprn_summary ds
where ds.deprn_reserve = 0
and ds.book_type_code = p_book_type_code
and ds.asset_id = p_asset_id
and ds.deprn_source_code = 'BOOKS')
and not exists(select 1 from fa_transaction_headers th2
where asset_id = p_asset_id
and book_type_code = p_book_type_code
and transaction_type_code not in ('TRANSFER OUT', 'TRANSFER IN',
'TRANSFER', 'TRANSFER IN/VOID',
'RECLASS', 'UNIT ADJUSTMENT',
'REINSTATEMENT', 'ADDITION/VOID',
'ADDITION', 'CIP ADDITION',
'CIP ADJUSTMENT', 'CIP ADDITION/VOID')
and nvl(th2.amortization_start_date, th2.transaction_date_entered) <
nvl(th.amortization_start_date, th.transaction_date_entered)
)
)
)
)
)
;
select fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM period_counter
, cp.start_date calendar_period_open_date
, cp.end_date calendar_period_close_date
, cp.period_num period_num
, fy.fiscal_year fiscal_year
, 0 cost
, 0 recoverable_cost
, 0 adjusted_recoverable_cost
, 0 adjusted_cost
, 0 reval_amortization_basis
, null ceiling_name
, null bonus_rule
, null allowed_deprn_limit
, null percent_salvage_value
, null salvage_value
, 0 change_in_sal
, null allowed_deprn_limit_amount
, 0 change_in_limit
, 'YES' depreciate_flag
, p_date_placed_in_service date_placed_in_service
, null deprn_method_code
, 0 life_in_months
, 0 adjusted_rate
, 0 production_capacity
, 0 adjusted_capacity
, 0 expense_adjustment_amount
, 0 reserve_adjustment_amount
, 0 ytd_proceeds_of_sale
, 0 ltd_proceeds_of_sale
, 0 ytd_cost_of_removal
, 0 ltd_cost_of_removal
, 0 change_in_cost
, 0 change_in_cip_cost
, 'N' reset_adjusted_cost_flag
, 0 transaction_header_id
, 0 change_in_retirements_cost
, 0 change_in_eofy_reserve
, 0 reval_reserve
, 0 bonus_deprn_amount
, 0 bonus_ytd_deprn
, 0 bonus_deprn_reserve
, 0 impairment_amount
, 0 ytd_impairment
, 0 impairment_reserve
, 1 rate_adjustment_factor
, 1 formula_factor
, null salvage_type
, null deprn_limit_type
, 0 deprn_amount
, 0 ytd_deprn
, 0 deprn_reserve
, 0 ltd_production
, 0 ytd_production
, 0 production
, 'Y' capitalized_flag
, 0 unplanned_amount
, 0 eofy_adj_cost
, 0 eofy_formula_factor
, 0 eofy_reserve
, 0 eop_adj_cost
, 0 bonus_rate
from fa_fiscal_year fy
, fa_calendar_types ct
, fa_calendar_periods cp
where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
and ct.calendar_type = cp.calendar_type
and cp.start_date between fy.start_date and fy.end_date
and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
and cp.end_date >= p_date_placed_in_service
order by period_counter;
SELECT sum(decode(debit_credit_flag, 'CR', -1, 1) * adjustment_amount)
FROM fa_adjustments
WHERE transaction_header_id = c_transaction_header_id
AND asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND source_type_code = c_source_type_code
AND adjustment_type = c_adjustment_type;
SELECT ytd_deprn
, deprn_reserve
FROM fa_deprn_summary
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND deprn_source_code = 'BOOKS';
select ret.cost_retired
from fa_retirements ret
where ret.transaction_header_id_in = c_transaction_header_id
and ret.transaction_header_id_out is null;
fa_debug_pkg.add(l_calling_fn,'Inserting into FA_BOOKS_SUMMARY_T',
fa_amort_pvt.t_period_counter.count, p_log_level_rec => p_log_level_rec);
INSERT INTO FA_BOOKS_SUMMARY_T(
REQUEST_ID
, IMPAIRMENT_ID
, ASSET_ID
, BOOK_TYPE_CODE
, PERIOD_COUNTER
, FISCAL_YEAR
, PERIOD_NUM
, CALENDAR_PERIOD_OPEN_DATE
, CALENDAR_PERIOD_CLOSE_DATE
, RESET_ADJUSTED_COST_FLAG
, CHANGE_IN_COST
-- , CHANGE_IN_ADDITIONS_COST
-- , CHANGE_IN_ADJUSTMENTS_COST
-- , CHANGE_IN_RETIREMENTS_COST
-- , CHANGE_IN_GROUP_REC_COST
, CHANGE_IN_CIP_COST
, COST
-- , CIP_COST
, SALVAGE_TYPE
, PERCENT_SALVAGE_VALUE
, SALVAGE_VALUE
-- , MEMBER_SALVAGE_VALUE
, RECOVERABLE_COST
, DEPRN_LIMIT_TYPE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
-- , MEMBER_DEPRN_LIMIT_AMOUNT
, ADJUSTED_RECOVERABLE_COST
, ADJUSTED_COST
, DEPRECIATE_FLAG
-- , DISABLED_FLAG
, DATE_PLACED_IN_SERVICE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR
, ADJUSTED_RATE
, BONUS_RULE
, ADJUSTED_CAPACITY
, PRODUCTION_CAPACITY
-- , UNIT_OF_MEASURE
-- , REMAINING_LIFE1
-- , REMAINING_LIFE2
, FORMULA_FACTOR
-- , UNREVALUED_COST
, REVAL_AMORTIZATION_BASIS
-- , REVAL_CEILING
, CEILING_NAME
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, EOFY_RESERVE
, EOP_ADJ_COST
-- , EOP_FORMULA_FACTOR
-- , SHORT_FISCAL_YEAR_FLAG
-- , GROUP_ASSET_ID
-- , SUPER_GROUP_ID
-- , OVER_DEPRECIATE_OPTION
-- , FULLY_RSVD_REVALS_COUNTER
, CAPITALIZED_FLAG
-- , FULLY_RESERVED_FLAG
-- , FULLY_RETIRED_FLAG
-- , LIFE_COMPLETE_FLAG
-- , TERMINAL_GAIN_LOSS_AMOUNT
-- , TERMINAL_GAIN_LOSS_FLAG
, DEPRN_AMOUNT
, YTD_DEPRN
, DEPRN_RESERVE
, BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, BONUS_RATE
, LTD_PRODUCTION
, YTD_PRODUCTION
, PRODUCTION
--n , REVAL_AMORTIZATION
--n , REVAL_DEPRN_EXPENSE
, REVAL_RESERVE
--n , YTD_REVAL_DEPRN_EXPENSE
--n , DEPRN_OVERRIDE_FLAG
--n , SYSTEM_DEPRN_AMOUNT
--n , SYSTEM_BONUS_DEPRN_AMOUNT
, YTD_PROCEEDS_OF_SALE
, LTD_PROCEEDS_OF_SALE
, YTD_COST_OF_REMOVAL
, LTD_COST_OF_REMOVAL
-- , DEPRN_ADJUSTMENT_AMOUNT
, EXPENSE_ADJUSTMENT_AMOUNT
, UNPLANNED_AMOUNT
, RESERVE_ADJUSTMENT_AMOUNT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
-- , LAST_UPDATE_LOGIN
, CHANGE_IN_EOFY_RESERVE
-- , SWITCH_CODE
-- , POLISH_DEPRN_BASIS
-- , POLISH_ADJ_REC_COST
, IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE
) VALUES(
p_request_id
, p_impairment_id
, p_asset_id
, p_book_type_code
, fa_amort_pvt.t_period_counter(i)
, fa_amort_pvt.t_fiscal_year(i)
, fa_amort_pvt.t_period_num(i)
, fa_amort_pvt.t_calendar_period_open_date(i)
, fa_amort_pvt.t_calendar_period_close_date(i)
, fa_amort_pvt.t_reset_adjusted_cost_flag(i)
, fa_amort_pvt.t_change_in_cost(i)
, fa_amort_pvt.t_change_in_cip_cost(i)
, fa_amort_pvt.t_cost(i)
, fa_amort_pvt.t_salvage_type(i)
, fa_amort_pvt.t_percent_salvage_value(i)
, fa_amort_pvt.t_salvage_value(i)
, fa_amort_pvt.t_recoverable_cost(i)
, fa_amort_pvt.t_deprn_limit_type(i)
, fa_amort_pvt.t_allowed_deprn_limit(i)
, fa_amort_pvt.t_allowed_deprn_limit_amount(i)
, fa_amort_pvt.t_adjusted_recoverable_cost(i)
, fa_amort_pvt.t_adjusted_cost(i)
, fa_amort_pvt.t_depreciate_flag(i)
, fa_amort_pvt.t_date_placed_in_service(i)
, fa_amort_pvt.t_deprn_method_code(i)
, fa_amort_pvt.t_life_in_months(i)
, fa_amort_pvt.t_rate_adjustment_factor(i)
, fa_amort_pvt.t_adjusted_rate(i)
, fa_amort_pvt.t_bonus_rule(i)
, fa_amort_pvt.t_adjusted_capacity(i)
, fa_amort_pvt.t_production_capacity(i)
, fa_amort_pvt.t_formula_factor(i)
, fa_amort_pvt.t_reval_amortization_basis(i)
, fa_amort_pvt.t_ceiling_name(i)
, fa_amort_pvt.t_eofy_adj_cost(i)
, fa_amort_pvt.t_eofy_formula_factor(i)
, fa_amort_pvt.t_eofy_reserve(i)
, fa_amort_pvt.t_eop_adj_cost(i)
, fa_amort_pvt.t_capitalized_flag(i)
, fa_amort_pvt.t_deprn_amount(i)
, fa_amort_pvt.t_ytd_deprn(i)
, fa_amort_pvt.t_deprn_reserve(i)
, fa_amort_pvt.t_bonus_deprn_amount(i)
, fa_amort_pvt.t_bonus_ytd_deprn(i)
, fa_amort_pvt.t_bonus_deprn_reserve(i)
, fa_amort_pvt.t_bonus_rate(i)
, fa_amort_pvt.t_ltd_production(i)
, fa_amort_pvt.t_ytd_production(i)
, fa_amort_pvt.t_production(i)
, fa_amort_pvt.t_reval_reserve(i)
, fa_amort_pvt.t_ytd_proceeds_of_sale(i)
, fa_amort_pvt.t_ltd_proceeds_of_sale(i)
, fa_amort_pvt.t_ytd_cost_of_removal(i)
, fa_amort_pvt.t_ltd_cost_of_removal(i)
, fa_amort_pvt.t_expense_adjustment_amount(i)
, fa_amort_pvt.t_unplanned_amount(i)
, fa_amort_pvt.t_reserve_adjustment_amount(i)
, sysdate
, FND_GLOBAL.USER_ID
, sysdate
, FND_GLOBAL.USER_ID
, fa_amort_pvt.t_change_in_eofy_reserve(i)
, fa_amort_pvt.t_impairment_amount(i)
, fa_amort_pvt.t_ytd_impairment(i)
, fa_amort_pvt.t_impairment_reserve(i)
);
SELECT
imp.asset_id
, imp.impairment_amount
, imp.rowid
FROM fa_itf_impairments imp
WHERE imp.book_type_code = p_book_type_code
AND imp.request_id = p_request_id
AND imp.period_counter <= p_period_rec.period_counter
AND imp.worker_id = p_worker_id;
SELECT PERIOD_COUNTER
, FISCAL_YEAR
, PERIOD_NUM
, CALENDAR_PERIOD_OPEN_DATE
, CALENDAR_PERIOD_CLOSE_DATE
, RESET_ADJUSTED_COST_FLAG
, CHANGE_IN_COST
-- , CHANGE_IN_ADDITIONS_COST
-- , CHANGE_IN_ADJUSTMENTS_COST
-- , CHANGE_IN_RETIREMENTS_COST
-- , CHANGE_IN_GROUP_REC_COST
, CHANGE_IN_CIP_COST
, COST
-- , CIP_COST
, SALVAGE_TYPE
, PERCENT_SALVAGE_VALUE
, SALVAGE_VALUE
-- , MEMBER_SALVAGE_VALUE
, RECOVERABLE_COST
, DEPRN_LIMIT_TYPE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
-- , MEMBER_DEPRN_LIMIT_AMOUNT
, ADJUSTED_RECOVERABLE_COST
, ADJUSTED_COST
, DEPRECIATE_FLAG
-- , DISABLED_FLAG
, DATE_PLACED_IN_SERVICE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR
, ADJUSTED_RATE
, BONUS_RULE
, ADJUSTED_CAPACITY
, PRODUCTION_CAPACITY
-- , UNIT_OF_MEASURE
-- , REMAINING_LIFE1
-- , REMAINING_LIFE2
, FORMULA_FACTOR
-- , UNREVALUED_COST
, REVAL_AMORTIZATION_BASIS
-- , REVAL_CEILING
, CEILING_NAME
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, EOFY_RESERVE
, EOP_ADJ_COST
-- , EOP_FORMULA_FACTOR
-- , SHORT_FISCAL_YEAR_FLAG
-- , GROUP_ASSET_ID
-- , SUPER_GROUP_ID
-- , OVER_DEPRECIATE_OPTION
-- , FULLY_RSVD_REVALS_COUNTER
, CAPITALIZED_FLAG
-- , FULLY_RESERVED_FLAG
-- , FULLY_RETIRED_FLAG
-- , LIFE_COMPLETE_FLAG
-- , TERMINAL_GAIN_LOSS_AMOUNT
-- , TERMINAL_GAIN_LOSS_FLAG
, DEPRN_AMOUNT
, YTD_DEPRN
, DEPRN_RESERVE
, BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, BONUS_RATE
, LTD_PRODUCTION
, YTD_PRODUCTION
, PRODUCTION
--n , REVAL_AMORTIZATION
--n , REVAL_DEPRN_EXPENSE
, REVAL_RESERVE
--n , YTD_REVAL_DEPRN_EXPENSE
--n , DEPRN_OVERRIDE_FLAG
--n , SYSTEM_DEPRN_AMOUNT
--n , SYSTEM_BONUS_DEPRN_AMOUNT
, YTD_PROCEEDS_OF_SALE
, LTD_PROCEEDS_OF_SALE
, YTD_COST_OF_REMOVAL
, LTD_COST_OF_REMOVAL
-- , DEPRN_ADJUSTMENT_AMOUNT
, EXPENSE_ADJUSTMENT_AMOUNT
, UNPLANNED_AMOUNT
, RESERVE_ADJUSTMENT_AMOUNT
-- , CREATION_DATE
-- , CREATED_BY
-- , LAST_UPDATE_DATE
-- , LAST_UPDATED_BY
-- , LAST_UPDATE_LOGIN
, CHANGE_IN_EOFY_RESERVE
-- , SWITCH_CODE
-- , POLISH_DEPRN_BASIS
-- , POLISH_ADJ_REC_COST
, IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE
FROM fa_books_summary_t
WHERE asset_id = c_asset_id
AND book_type_code = p_book_type_code
AND period_counter >= p_imp_period_rec.period_counter
AND request_id = p_request_id
ORDER BY period_counter;
UPDATE FA_ITF_IMPAIRMENTS
SET DEPRN_ADJUSTMENT_AMOUNT = t_catchup(k)
, ADJUSTED_COST = t_adjusted_cost(k)
, RATE_ADJUSTMENT_FACTOR = t_raf(k)
, FORMULA_FACTOR = t_formula_factor(k)
, EOFY_RESERVE = t_eofy_reserve(k)
WHERE ROWID = t_rowid(k);