APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_MC_DEPRN_SUMMARY

Line 163: insert into fa_mc_deprn_summary_h

159: if (p_reversal_event_id is not null) then
160:
161: if (p_mrc_sob_type_code = 'R') then
162:
163: insert into fa_mc_deprn_summary_h
164: (SET_OF_BOOKS_ID ,
165: BOOK_TYPE_CODE ,
166: ASSET_ID ,
167: DEPRN_RUN_DATE ,

Line 238: from fa_mc_deprn_summary ds

234: EVENT_ID ,
235: DEPRN_RUN_ID ,
236: P_REVERSAL_EVENT_ID ,
237: P_REVERSAL_DATE
238: from fa_mc_deprn_summary ds
239: where ds.book_type_code = p_asset_hdr_rec.book_type_code
240: and ds.asset_id = p_asset_hdr_rec.asset_id
241: and ds.period_counter = p_period_rec.period_counter
242: and ds.deprn_source_code in ('DEPRN','TRACK')

Line 545: From fa_mc_deprn_summary ds2, fa_mc_deprn_summary ds1, fa_mc_books bk2

541: bk2.eop_formula_factor)),
542: Decode(bk2.eop_adj_cost,
543: null, bk2.adjusted_capacity,
544: bk2.old_adjusted_capacity)
545: From fa_mc_deprn_summary ds2, fa_mc_deprn_summary ds1, fa_mc_books bk2
546: where bk2.transaction_header_id_in = bk.transaction_header_id_in
547: and bk2.set_of_books_id = p_asset_hdr_rec.set_of_books_id
548: and ds2.asset_id(+) = bk2.asset_id
549: and ds2.book_type_code(+) = bk2.book_type_code

Line 664: from fa_mc_deprn_summary ds

660: -- delete from DS
661:
662: if (p_mrc_sob_type_code = 'R') then
663: delete
664: from fa_mc_deprn_summary ds
665: where ds.asset_id = p_asset_hdr_rec.asset_id
666: and ds.book_type_code = p_asset_hdr_rec.book_type_code
667: and ds.period_counter = p_period_rec.period_counter
668: and ds.deprn_source_code in ('DEPRN','TRACK')