APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_MC_DEPRN_DETAIL

Line 148: delete from fa_mc_deprn_detail

144: and set_of_books_id = p_set_of_books_id;
145: end if;
146:
147: FORALL i in 1..t_thid.count
148: delete from fa_mc_deprn_detail
149: where asset_id = t_asset_id(i)
150: and book_type_code = p_book_type_code
151: and period_counter = p_period_rec.period_counter
152: and set_of_books_id = p_set_of_books_id;

Line 925: insert into fa_mc_deprn_detail_h

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');
924:
925: insert into fa_mc_deprn_detail_h
926: (SET_OF_BOOKS_ID ,
927: BOOK_TYPE_CODE ,
928: ASSET_ID ,
929: PERIOD_COUNTER ,

Line 987: from fa_mc_deprn_detail ds

983: EVENT_ID ,
984: DEPRN_RUN_ID ,
985: decode(set_of_books_id,l_secondary_sob_id, l_secondary_rev_event_id,l_rev_event_id),
986: l_sysdate
987: from fa_mc_deprn_detail ds
988: where ds.book_type_code = p_book_type_code
989: and ds.asset_id = p_asset_id
990: and ds.period_counter = l_period_rec.period_counter
991: and ds.deprn_source_code in ('D','T');