DBA Data[Home] [Help]

APPS.FA_TAX_UPLOAD_PKG dependencies on FA_ADJUSTMENTS

Line 762: -- now fetch any existing catchup expense in fa_adjustments

758: end if;
759:
760: if (l_asset_hdr_rec.period_of_addition <> 'Y' or
761: G_release = 11) then
762: -- now fetch any existing catchup expense in fa_adjustments
763: -- and account for this when calculating the old deprn values
764: -- only if it is not in period of addition
765:
766: select nvl(sum(decode(debit_credit_flag,

Line 770: from fa_adjustments

766: select nvl(sum(decode(debit_credit_flag,
767: 'DR', adjustment_amount,
768: -adjustment_amount)), 0)
769: into l_deprn_exp_amort_nbv
770: from fa_adjustments
771: where book_type_code = l_asset_hdr_rec.book_type_code
772: and asset_id = l_asset_hdr_rec.asset_id
773: and source_type_code = 'DEPRECIATION'
774: and adjustment_type = 'EXPENSE';