APPS.FA_EXP_PVT SQL Statements

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

Line: 172

         select fiscal_year, period_num
         into   l_prorate_fy, l_start_per_num
         from   fa_deprn_periods
         where  period_counter = px_asset_fin_rec_new.extended_depreciation_period
         and    book_type_code = p_asset_hdr_rec.book_type_code;

Line: 271

      select bk_old.adjusted_cost
      from fa_books bk_old, fa_books bk_extnd
      where bk_old.book_type_code = p_book_type_code and
            bk_old.asset_id = p_asset_id and
            bk_old.extended_depreciation_period is null and
            bk_extnd.book_type_code = p_book_type_code and
            bk_extnd.asset_id = p_asset_id and
            bk_extnd.extended_depreciation_period is not null and
            bk_extnd.transaction_header_id_in = bk_old.transaction_header_id_out
      order by bk_extnd.transaction_header_id_in desc;

Line: 348

         l_dpr.update_override_status := TRUE;