APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_MC_DEPRN_SUMMARY

Line 155: delete from fa_mc_deprn_summary

151: and period_counter = p_period_rec.period_counter
152: and set_of_books_id = p_set_of_books_id;
153:
154: FORALL i in 1..t_thid.count
155: delete from fa_mc_deprn_summary
156: where asset_id = t_asset_id(i)
157: and book_type_code = p_book_type_code
158: and period_counter = p_period_rec.period_counter
159: and set_of_books_id = p_set_of_books_id;

Line 843: insert into fa_mc_deprn_summary_h

839: and ds.asset_id = p_asset_id
840: and ds.period_counter = l_period_rec.period_counter
841: and ds.deprn_source_code in ('D','T');
842:
843: insert into fa_mc_deprn_summary_h
844: (SET_OF_BOOKS_ID ,
845: BOOK_TYPE_CODE ,
846: ASSET_ID ,
847: DEPRN_RUN_DATE ,

Line 919: from fa_mc_deprn_summary ds

915: EVENT_ID ,
916: DEPRN_RUN_ID ,
917: decode(set_of_books_id,l_secondary_sob_id, l_secondary_rev_event_id,l_rev_event_id) ,
918: l_sysdate
919: from fa_mc_deprn_summary ds
920: where ds.book_type_code = p_book_type_code
921: and ds.asset_id = p_asset_id
922: and ds.period_counter = l_period_rec.period_counter
923: and ds.deprn_source_code in ('DEPRN','TRACK');