APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_DEPRN_SUMMARY

Line 120: insert into fa_deprn_summary_h_mrc_v

116: if (p_reversal_event_id is not null) then
117:
118: if (p_mrc_sob_type_code = 'R') then
119:
120: insert into fa_deprn_summary_h_mrc_v
121: (BOOK_TYPE_CODE ,
122: ASSET_ID ,
123: DEPRN_RUN_DATE ,
124: DEPRN_AMOUNT ,

Line 181: from fa_deprn_summary_mrc_v ds

177: EVENT_ID ,
178: DEPRN_RUN_ID ,
179: P_REVERSAL_EVENT_ID ,
180: P_REVERSAL_DATE
181: from fa_deprn_summary_mrc_v ds
182: where ds.book_type_code = p_asset_hdr_rec.book_type_code
183: and ds.asset_id = p_asset_hdr_rec.asset_id
184: and ds.period_counter = p_period_rec.period_counter
185: and ds.deprn_source_code in ('DEPRN','TRACK');

Line 245: insert into fa_deprn_summary_h

241:
242: else
243:
244: -- archive the prior info into the backup table
245: insert into fa_deprn_summary_h
246: (BOOK_TYPE_CODE ,
247: ASSET_ID ,
248: DEPRN_RUN_DATE ,
249: DEPRN_AMOUNT ,

Line 306: from fa_deprn_summary ds

302: EVENT_ID ,
303: DEPRN_RUN_ID ,
304: P_REVERSAL_EVENT_ID ,
305: P_REVERSAL_DATE
306: from fa_deprn_summary ds
307: where ds.book_type_code = p_asset_hdr_rec.book_type_code
308: and ds.asset_id = p_asset_hdr_rec.asset_id
309: and ds.period_counter = p_period_rec.period_counter
310: and ds.deprn_source_code in ('DEPRN','TRACK');

Line 402: -- from fa_deprn_summary's BOOKS row

398:
399: -- Bug# 3798413: Reset adjusted_cost back to the original adjusted_cost
400: -- for the addition transaction.
401: -- For period of addition transaction, we are getting the value
402: -- from fa_deprn_summary's BOOKS row
403: -- since Adj API also sets adjusted_cost in BOOKS' row to the latest value
404: -- before depreciation correctly.
405: --
406: -- BUG# 4094166

Line 454: From fa_deprn_summary_mrc_v ds2, fa_deprn_summary_mrc_v ds1, fa_books_mrc_v bk2

450: bk2.eop_formula_factor)),
451: Decode(bk2.eop_adj_cost,
452: null, bk2.adjusted_capacity,
453: bk2.old_adjusted_capacity)
454: From fa_deprn_summary_mrc_v ds2, fa_deprn_summary_mrc_v ds1, fa_books_mrc_v bk2
455: where bk2.transaction_header_id_in = bk.transaction_header_id_in
456: and ds2.asset_id(+) = bk2.asset_id
457: and ds2.book_type_code(+) = bk2.book_type_code
458: and ds2.period_counter(+) = (p_period_rec.period_counter - 1)

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

525: bk2.eop_formula_factor)),
526: Decode(bk2.eop_adj_cost,
527: null, bk2.adjusted_capacity,
528: bk2.old_adjusted_capacity)
529: From fa_deprn_summary ds2, fa_deprn_summary ds1, fa_books bk2
530: where bk2.transaction_header_id_in = bk.transaction_header_id_in
531: and ds2.asset_id(+) = bk2.asset_id
532: and ds2.book_type_code(+) = bk2.book_type_code
533: and ds2.period_counter(+) = (p_period_rec.period_counter - 1)

Line 565: from fa_deprn_summary_mrc_v ds

561: -- delete from DS
562:
563: if (p_mrc_sob_type_code = 'R') then
564: delete
565: from fa_deprn_summary_mrc_v ds
566: where ds.asset_id = p_asset_hdr_rec.asset_id
567: and ds.book_type_code = p_asset_hdr_rec.book_type_code
568: and ds.period_counter = p_period_rec.period_counter
569: and ds.deprn_source_code in ('DEPRN','TRACK');

Line 572: from fa_deprn_summary ds

568: and ds.period_counter = p_period_rec.period_counter
569: and ds.deprn_source_code in ('DEPRN','TRACK');
570: else
571: delete
572: from fa_deprn_summary ds
573: where ds.asset_id = p_asset_hdr_rec.asset_id
574: and ds.book_type_code = p_asset_hdr_rec.book_type_code
575: and ds.period_counter = p_period_rec.period_counter
576: and ds.deprn_source_code in ('DEPRN','TRACK');