DBA Data[Home] [Help]

APPS.JA_AU_FA_BAL_CHG dependencies on FA_RETIREMENTS

Line 228: fa_retirements r

224: update ja_au_srw_tax_deprn_tmp t
225: set date_retired =
226: (select max(r.date_retired)
227: from fa_transaction_headers th,
228: fa_retirements r
229: where th.asset_id = t.asset_id
230: and th.book_type_code = v_book_type_code
231: and th.date_effective <= v_to_date
232: and th.transaction_type_code = 'FULL RETIREMENT'

Line 255: fa_retirements r

251: update ja_au_srw_tax_deprn_tmp t
252: set (date_retired, net_book_value) =
253: (select max(r.date_retired), sum(nvl(r.nbv_retired,0))
254: from fa_transaction_headers th,
255: fa_retirements r
256: where th.asset_id = t.asset_id
257: and th.book_type_code = v_book_type_code
258: and th.date_effective between v_from_date and v_to_date
259: and th.transaction_type_code in ('PARTIAL RETIREMENT','FULL RETIREMENT')

Line 448: FA_RETIREMENTS R,

444: nvl(r.gain_loss_amount,0) gain_loss_amount,
445: nvl(r.cost_retired,0) - nvl(r.nbv_retired,0) deprn_retired
446: from FA_DEPRN_PERIODS DP,
447: FA_TRANSACTION_HEADERS TH,
448: FA_RETIREMENTS R,
449: FA_ADDITIONS A,
450: FA_BOOKS B
451: where dp.period_name = (v_period_name)
452: