APPS.FA_TAX_RSV_ADJ_PUB SQL Statements

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

Line: 241

   SELECT MAX(DP.PERIOD_COUNTER),
          MIN(DP.PERIOD_COUNTER)
   INTO   l_asset_tax_rsv_adj_rec.max_period_ctr_adjusted,
          l_asset_tax_rsv_adj_rec.min_period_ctr_adjusted
   FROM   FA_DEPRN_PERIODS DP
   WHERE  DP.BOOK_TYPE_CODE = px_asset_hdr_rec.book_type_code
   AND    DP.FISCAL_YEAR = l_asset_tax_rsv_adj_rec.fiscal_year;

Line: 270

   SELECT count(*)
   into   l_count
   from   fa_transaction_headers th,
          fa_deprn_periods dp,
          fa_book_controls bc
   where  th.asset_id = px_asset_hdr_rec.asset_id
   and    th.book_type_code = px_asset_hdr_rec.book_type_code
   and    th.transaction_key = 'IM'
   and    th.date_effective > dp.period_open_date
   and    dp.book_type_code = th.book_type_code
   and    dp.period_num = 1
   and    bc.book_type_code = th.book_type_code
   and    bc.current_fiscal_year = dp.fiscal_year
   and    bc.book_type_code = dp.book_type_code;

Line: 382

   SELECT 1
   FROM  FA_TRANSACTION_HEADERS TH, FA_DEPRN_PERIODS DP
   WHERE TH.ASSET_ID = p_asset_id
   AND   TH.BOOK_TYPE_CODE = p_book
   AND   TH.TRANSACTION_SUBTYPE = 'AMORTIZED'
   AND   DP.PERIOD_COUNTER = p_period_counter
   AND   DP.BOOK_TYPE_CODE = p_book
   AND   DP.PERIOD_CLOSE_DATE < TH.DATE_EFFECTIVE;