APPS.FA_DEPRN_ROLLBACK_PUB SQL Statements

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

Line: 48

   select asset_id
     from fa_books
    where group_asset_id = p_group_asset_id
      and book_type_code = p_book_type_code
	  and transaction_header_id_out is null;

Line: 126

   select group_asset_id,
          tracking_method
     into l_group_asset_id,
          l_tracking_method
     from fa_books
    where asset_id       = px_asset_hdr_rec.asset_id
      and book_type_code = px_asset_hdr_rec.book_type_code
      and transaction_header_id_out is null;

Line: 302

      select event_id, deprn_run_id
        into l_event_id,
             l_deprn_run_id
        from fa_deprn_events_v de
       where de.book_type_code = px_asset_hdr_rec.book_type_code
         and de.asset_id       = px_asset_hdr_rec.asset_id
         and de.period_counter = l_period_rec.period_counter
         and de.reversal_event_id is null;

Line: 399

         XLA_EVENTS_PUB_PKG.delete_event
            (p_event_source_info            => l_deprn_source_info,
             p_event_id                     => l_event_id,
             p_valuation_method             => px_asset_hdr_rec.book_type_code,
             p_security_context             => l_security_context);

Line: 459

         select count(*)
           into l_deprn_count
           from fa_deprn_summary ds
          where ds.book_type_code = px_asset_hdr_rec.book_type_code
            and ds.asset_id       = px_asset_hdr_rec.asset_id
            and ds.period_counter = l_period_rec.period_counter;

Line: 466

         select count(*)
           into l_deprn_count
           from fa_deprn_summary_mrc_v ds
          where ds.book_type_code = px_asset_hdr_rec.book_type_code
            and ds.asset_id       = px_asset_hdr_rec.asset_id
            and ds.period_counter = l_period_rec.period_counter;