DBA Data[Home] [Help]

APPS.JL_ZZ_FA_REVAL_RULES_PKG dependencies on FA_DEPRN_PERIODS

Line 234: FROM fa_deprn_periods

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

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

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

Line 526: FROM fa_deprn_periods dp

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