APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_DEPRN_SUMMARY_MRC_V

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 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 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');