APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_DEPRN_DETAIL

Line 252: delete from fa_deprn_detail

248: and period_counter_created = p_period_rec.period_counter;
249: end if;
250:
251: FORALL i in 1..t_thid.count
252: delete from fa_deprn_detail
253: where asset_id = t_asset_id(i)
254: and book_type_code = p_book_type_code
255: and period_counter = p_period_rec.period_counter;
256:

Line 777: insert into fa_deprn_detail_h

773: and ds.asset_id = p_asset_id
774: and ds.period_counter = l_period_rec.period_counter
775: and ds.deprn_source_code in ('DEPRN','TRACK');
776:
777: insert into fa_deprn_detail_h
778: (BOOK_TYPE_CODE ,
779: ASSET_ID ,
780: PERIOD_COUNTER ,
781: DISTRIBUTION_ID ,

Line 837: from fa_deprn_detail ds

833: EVENT_ID ,
834: DEPRN_RUN_ID ,
835: l_rev_event_id ,
836: l_sysdate
837: from fa_deprn_detail ds
838: where ds.book_type_code = p_book_type_code
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');