DBA Data[Home] [Help]

APPS.JL_ZZ_FA_REVAL_RULES_PKG dependencies on FA_DEPRN_PERIODS

Line 232: FROM fa_deprn_periods

228: , g_current_period_to_date1
229: , g_current_fiscal_year
230: , g_current_period_counter1
231: , g_period_open_date
232: FROM fa_deprn_periods
233: WHERE book_type_code = p_book_type_code
234: AND period_close_date IS NULL;
235:
236:

Line 400: -- Gets the period_close_date from fa_deprn_periods for --

396:
397: ------------------------------------------------------------
398: -- Procedure: get_close_date --
399: -- --
400: -- Gets the period_close_date from fa_deprn_periods for --
401: -- the book_type_code and a given date. If country is --
402: -- Chile then gets the calendar_period_close_date for --
403: -- previous period at the retired or placed in service. --
404: -- Bug 1974991 : The algorithm of figuring out period ---

Line 524: FROM fa_deprn_periods dp

520: --
521: BEGIN
522: SELECT min(dp.period_counter)
523: INTO dummy
524: FROM fa_deprn_periods dp
525: , fa_transaction_headers th
526: , fa_asset_history ah
527: WHERE ah.asset_id = th.asset_id
528: AND dp.book_type_code = th.book_type_code