APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_DEPRN_DETAIL_MRC_V

Line 236: from fa_deprn_detail_mrc_v ds

232: EVENT_ID ,
233: DEPRN_RUN_ID ,
234: P_REVERSAL_EVENT_ID ,
235: P_REVERSAL_DATE
236: from fa_deprn_detail_mrc_v ds
237: where ds.book_type_code = p_asset_hdr_rec.book_type_code
238: and ds.asset_id = p_asset_hdr_rec.asset_id
239: and ds.period_counter = p_period_rec.period_counter
240: and ds.deprn_source_code in ('D','T');

Line 584: from fa_deprn_detail_mrc_v dd

580: -- delete from DD
581:
582: if (p_mrc_sob_type_code = 'R') then
583: delete
584: from fa_deprn_detail_mrc_v dd
585: where dd.asset_id = p_asset_hdr_rec.asset_id
586: and dd.book_type_code = p_asset_hdr_rec.book_type_code
587: and dd.period_counter = p_period_rec.period_counter
588: and dd.deprn_source_code in ('D','T');