APPS.FA_TAX_RSV_ADJ_PUB dependencies on FA_DEPRN_PERIODS

Line 245: FROM FA_DEPRN_PERIODS DP

241: SELECT MAX(DP.PERIOD_COUNTER),
242: MIN(DP.PERIOD_COUNTER)
243: INTO l_asset_tax_rsv_adj_rec.max_period_ctr_adjusted,
244: l_asset_tax_rsv_adj_rec.min_period_ctr_adjusted
245: FROM FA_DEPRN_PERIODS DP
246: WHERE DP.BOOK_TYPE_CODE = px_asset_hdr_rec.book_type_code
247: AND DP.FISCAL_YEAR = l_asset_tax_rsv_adj_rec.fiscal_year;
248:
249:

Line 273: fa_deprn_periods dp,

269: -- check if impairment has been in the current fiscal year. if so error
270: SELECT count(*)
271: into l_count
272: from fa_transaction_headers th,
273: fa_deprn_periods dp,
274: fa_book_controls bc
275: where th.asset_id = px_asset_hdr_rec.asset_id
276: and th.book_type_code = px_asset_hdr_rec.book_type_code
277: and th.transaction_key = 'IM'

Line 383: FROM FA_TRANSACTION_HEADERS TH, FA_DEPRN_PERIODS DP

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