APPS.JA_AU_FA_BAL_CHG dependencies on FA_TRANSACTION_HEADERS

Line 227: from fa_transaction_headers th,

223:
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

Line 234: from fa_transaction_headers th2

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'
233: and not exists (select '1'
234: from fa_transaction_headers th2
235: where th2.asset_id = t.asset_id
236: and th2.book_type_code = v_book_type_code
237: and th2.date_effective <= v_to_date
238: and th2.transaction_header_id > th.transaction_header_id

Line 254: from fa_transaction_headers th,

250:
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

Line 261: from fa_transaction_headers th2

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')
260: and not exists (select '1'
261: from fa_transaction_headers th2
262: where th2.asset_id = t.asset_id
263: and th2.book_type_code = v_book_type_code
264: and th2.date_effective between v_from_date and v_to_date
265: and th2.transaction_header_id > th.transaction_header_id

Line 325: from fa_transaction_headers th

321:
322: update ja_au_srw_tax_deprn_tmp t
323: set addition_date =
324: (select th.date_effective
325: from fa_transaction_headers th
326: where th.asset_id = t.asset_id
327: and th.book_type_code = v_book_type_code
328: and th.transaction_type_code = 'ADDITION'
329: and th.date_effective between v_from_date and v_to_date);

Line 447: FA_TRANSACTION_HEADERS TH,

443: r.date_retired ,
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)