APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_MC_DEPRN_DETAIL

Line 245: insert into fa_mc_deprn_detail_h

241: and ds.period_counter = p_period_rec.period_counter
242: and ds.deprn_source_code in ('DEPRN','TRACK')
243: and ds.set_of_books_id = p_asset_hdr_rec.set_of_books_id;
244:
245: insert into fa_mc_deprn_detail_h
246: (SET_OF_BOOKS_ID ,
247: BOOK_TYPE_CODE ,
248: ASSET_ID ,
249: PERIOD_COUNTER ,

Line 306: from fa_mc_deprn_detail ds

302: EVENT_ID ,
303: DEPRN_RUN_ID ,
304: P_REVERSAL_EVENT_ID ,
305: P_REVERSAL_DATE
306: from fa_mc_deprn_detail 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 ('D','T')

Line 684: from fa_mc_deprn_detail dd

680: -- delete from DD
681:
682: if (p_mrc_sob_type_code = 'R') then
683: delete
684: from fa_mc_deprn_detail dd
685: where dd.asset_id = p_asset_hdr_rec.asset_id
686: and dd.book_type_code = p_asset_hdr_rec.book_type_code
687: and dd.period_counter = p_period_rec.period_counter
688: and dd.deprn_source_code in ('D','T')