APPS.FA_TXRSV_PKG dependencies on FA_DEPRN_PERIODS

Line 27: FROM FA_TRANSACTION_HEADERS TH, FA_DEPRN_PERIODS DP

23: return boolean is
24:
25: Cursor c_amort is
26: SELECT 1
27: FROM FA_TRANSACTION_HEADERS TH, FA_DEPRN_PERIODS DP
28: WHERE TH.ASSET_ID = X_asset_id AND
29: TH.BOOK_TYPE_CODE = X_book AND
30: TH.TRANSACTION_SUBTYPE = 'AMORTIZED'AND
31: DP.PERIOD_COUNTER = X_period_counter AND

Line 366: FROM FA_DEPRN_PERIODS DP

362: return boolean is
363:
364: CURSOR fiscal_year_cr is
365: SELECT DP.FISCAL_YEAR, MAX(DP.PERIOD_NUM),MAX(DP.PERIOD_COUNTER)
366: FROM FA_DEPRN_PERIODS DP
367: WHERE DP.BOOK_TYPE_CODE = X_fin_info_ptr.book
368: AND DP.FISCAL_YEAR > X_fiscal_year
369: AND DP.PERIOD_CLOSE_DATE IS NOT NULL
370: GROUP BY DP.FISCAL_YEAR

Line 441: FROM FA_DEPRN_PERIODS DP

437:
438: -- Find the first period adjusted
439: SELECT MAX(DP.PERIOD_COUNTER)
440: INTO period_ctr_adjusted
441: FROM FA_DEPRN_PERIODS DP
442: WHERE DP.BOOK_TYPE_CODE = X_fin_info_ptr.book
443: AND DP.FISCAL_YEAR = X_fiscal_year;
444:
445: