DBA Data[Home] [Help]

APPS.FA_TAX_UPLOAD_PKG dependencies on FA_ADJUSTMENTS

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

620: raise data_error;
621: end if;
622:
623: if (l_asset_hdr_rec.period_of_addition <> 'Y') then
624: -- now fetch any existing catchup expense in fa_adjustments
625: -- and account for this when calculating the old deprn values
626: -- only if it is not in period of addition
627: select nvl(sum(decode(debit_credit_flag,
628: 'DR', adjustment_amount,

Line 631: from fa_adjustments

627: select nvl(sum(decode(debit_credit_flag,
628: 'DR', adjustment_amount,
629: -adjustment_amount)), 0)
630: into l_deprn_exp_amort_nbv
631: from fa_adjustments
632: where book_type_code = l_asset_hdr_rec.book_type_code
633: and asset_id = l_asset_hdr_rec.asset_id
634: and source_type_code = 'DEPRECIATION'
635: and adjustment_type = 'EXPENSE';