APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_DEPRN_SUMMARY

Line 316: insert into fa_deprn_summary_h

312:
313: else
314:
315: -- archive the prior info into the backup table
316: insert into fa_deprn_summary_h
317: (BOOK_TYPE_CODE ,
318: ASSET_ID ,
319: DEPRN_RUN_DATE ,
320: DEPRN_AMOUNT ,

Line 389: from fa_deprn_summary ds

385: EVENT_ID ,
386: DEPRN_RUN_ID ,
387: P_REVERSAL_EVENT_ID ,
388: P_REVERSAL_DATE
389: from fa_deprn_summary ds
390: where ds.book_type_code = p_asset_hdr_rec.book_type_code
391: and ds.asset_id = p_asset_hdr_rec.asset_id
392: and ds.period_counter = p_period_rec.period_counter
393: and ds.deprn_source_code in ('DEPRN','TRACK');

Line 495: -- from fa_deprn_summary's BOOKS row

491:
492: -- Bug# 3798413: Reset adjusted_cost back to the original adjusted_cost
493: -- for the addition transaction.
494: -- For period of addition transaction, we are getting the value
495: -- from fa_deprn_summary's BOOKS row
496: -- since Adj API also sets adjusted_cost in BOOKS' row to the latest value
497: -- before depreciation correctly.
498: --
499: -- BUG# 4094166

Line 624: From fa_deprn_summary ds2, fa_deprn_summary ds1, fa_books bk2

620: bk2.eop_formula_factor)),
621: Decode(bk2.eop_adj_cost,
622: null, bk2.adjusted_capacity,
623: bk2.old_adjusted_capacity)
624: From fa_deprn_summary ds2, fa_deprn_summary ds1, fa_books bk2
625: where bk2.transaction_header_id_in = bk.transaction_header_id_in
626: and ds2.asset_id(+) = bk2.asset_id
627: and ds2.book_type_code(+) = bk2.book_type_code
628: and ds2.period_counter(+) = (p_period_rec.period_counter - 1)

Line 672: from fa_deprn_summary ds

668: and ds.deprn_source_code in ('DEPRN','TRACK')
669: and ds.set_of_books_id = p_asset_hdr_rec.set_of_books_id ;
670: else
671: delete
672: from fa_deprn_summary ds
673: where ds.asset_id = p_asset_hdr_rec.asset_id
674: and ds.book_type_code = p_asset_hdr_rec.book_type_code
675: and ds.period_counter = p_period_rec.period_counter
676: and ds.deprn_source_code in ('DEPRN','TRACK');