APPS.FA_TAX_RSV_ADJ_PUB dependencies on FA_DEPRN_PERIODS

Line 256: FROM FA_DEPRN_PERIODS DP

252: SELECT MAX(DP.PERIOD_COUNTER),
253: MIN(DP.PERIOD_COUNTER)
254: INTO l_asset_tax_rsv_adj_rec.max_period_ctr_adjusted,
255: l_asset_tax_rsv_adj_rec.min_period_ctr_adjusted
256: FROM FA_DEPRN_PERIODS DP
257: WHERE DP.BOOK_TYPE_CODE = px_asset_hdr_rec.book_type_code
258: AND DP.FISCAL_YEAR = l_asset_tax_rsv_adj_rec.fiscal_year;
259:
260:

Line 380: FROM FA_TRANSACTION_HEADERS TH, FA_DEPRN_PERIODS DP

376: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN is
377:
378: Cursor c_amort is
379: SELECT 1
380: FROM FA_TRANSACTION_HEADERS TH, FA_DEPRN_PERIODS DP
381: WHERE TH.ASSET_ID = p_asset_id
382: AND TH.BOOK_TYPE_CODE = p_book
383: AND TH.TRANSACTION_SUBTYPE = 'AMORTIZED'
384: AND DP.PERIOD_COUNTER = p_period_counter