DBA Data[Home] [Help]

APPS.FA_TAX_RSV_ADJ_PVT dependencies on FA_DEPRN_PERIODS

Line 96: FROM FA_DEPRN_PERIODS DP

92:
93:
94: CURSOR fiscal_year_cr (p_book_type_code FA_BOOKS.book_type_code%TYPE, p_fiscal_year Number) is
95: SELECT DP.FISCAL_YEAR, MAX(DP.PERIOD_NUM),MAX(DP.PERIOD_COUNTER)
96: FROM FA_DEPRN_PERIODS DP
97: WHERE DP.BOOK_TYPE_CODE = p_book_type_code
98: AND DP.FISCAL_YEAR > p_fiscal_year
99: AND DP.PERIOD_CLOSE_DATE IS NOT NULL
100: GROUP BY DP.FISCAL_YEAR