DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_DEPRN_SUMMARY

Line 258: delete from fa_deprn_summary

254: and book_type_code = p_book_type_code
255: and period_counter = p_period_rec.period_counter;
256:
257: FORALL i in 1..t_thid.count
258: delete from fa_deprn_summary
259: where asset_id = t_asset_id(i)
260: and book_type_code = p_book_type_code
261: and period_counter = p_period_rec.period_counter;
262:

Line 697: insert into fa_deprn_summary_h

693: and period_counter = l_period_rec.period_counter
694: and deprn_run_id = l_deprn_run_id;
695:
696: /*Bug# 8542247 - Added following code to archive depreciation record for audit trail */
697: insert into fa_deprn_summary_h
698: (BOOK_TYPE_CODE ,
699: ASSET_ID ,
700: DEPRN_RUN_DATE ,
701: DEPRN_AMOUNT ,

Line 771: from fa_deprn_summary ds

767: EVENT_ID ,
768: DEPRN_RUN_ID ,
769: l_rev_event_id ,
770: l_sysdate
771: from fa_deprn_summary ds
772: where ds.book_type_code = p_book_type_code
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');