APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_DEPRN_EVENTS

Line 524: from fa_deprn_events_v de

520: BEGIN
521: select event_id, deprn_run_id
522: into l_event_id,
523: l_deprn_run_id
524: from fa_deprn_events_v de
525: where de.book_type_code = p_book_type_code
526: and de.asset_id = p_asset_id
527: and de.period_counter = l_period_rec.period_counter
528: and de.reversal_event_id is null;

Line 664: DELETE from fa_deprn_events

660: fa_debug_pkg.add(l_calling_fn, 'l_result', l_result, p_log_level_rec => p_log_level_rec);
661: raise rb_err;
662: END; --annonymous
663:
664: DELETE from fa_deprn_events
665: where asset_id = p_asset_id
666: and book_type_code = p_book_type_code
667: and period_counter = l_period_rec.period_counter
668: and reversal_event_id is null;

Line 688: update fa_deprn_events

684: fa_debug_pkg.add(l_calling_fn, 'rollback event id', l_event_id, p_log_level_rec => p_log_level_rec);
685: end if;
686:
687: -- flag the header table too
688: update fa_deprn_events
689: set reversal_event_id = l_rev_event_id,
690: reversal_date = l_sysdate
691: where asset_id = p_asset_id
692: and book_type_code = p_book_type_code