DBA Data[Home] [Help]

APPS.FA_TAX_RSV_ADJ_PVT dependencies on FA_DEPRN_PERIODS

Line 90: FROM FA_DEPRN_PERIODS DP

86: TAX_RSV_ADJ_ERR EXCEPTION;
87:
88: CURSOR fiscal_year_cr (p_book_type_code FA_BOOKS.book_type_code%TYPE, p_fiscal_year Number) is
89: SELECT DP.FISCAL_YEAR, MAX(DP.PERIOD_NUM),MAX(DP.PERIOD_COUNTER)
90: FROM FA_DEPRN_PERIODS DP
91: WHERE DP.BOOK_TYPE_CODE = p_book_type_code
92: AND DP.FISCAL_YEAR > p_fiscal_year
93: AND DP.PERIOD_CLOSE_DATE IS NOT NULL
94: GROUP BY DP.FISCAL_YEAR