APPS.FA_DEPRN_ROLLBACK_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

   select asset_id
     from fa_deprn_summary
    where book_type_code = p_book_type_code
      and period_counter = l_period_counter;

Line: 122

   update fa_deprn_periods_mrc_v
      set deprn_run          = null
    where book_type_code     = p_book_type_code
      and period_counter     = l_period_counter
      and period_close_date is null
      and deprn_run          = 'Y';

Line: 129

   update fa_deprn_periods
      set deprn_run          = null
    where book_type_code     = p_book_type_code
      and period_counter     = l_period_counter
      and period_close_date is null
      and deprn_run          = 'Y';