DBA Data[Home] [Help]

APPS.FA_AMORT_PVT dependencies on FA_MC_DEPRN_PERIODS

Line 179: from fa_mc_deprn_periods

175: , calendar_period_open_date
176: , calendar_period_close_date
177: , fiscal_year
178: , period_num
179: from fa_mc_deprn_periods
180: where set_of_books_id = p_set_of_books_id
181: and book_type_code = p_book_type_code
182: and to_date (to_char (p_jdate), 'J') between calendar_period_open_date
183: and calendar_period_close_date;

Line 3441: from fa_mc_deprn_periods dp

3437: and dp.period_close_date is null;
3438:
3439: CURSOR c_get_current_period_mrc IS
3440: select dp.period_counter
3441: from fa_mc_deprn_periods dp
3442: where dp.book_type_code = p_asset_hdr_rec.book_type_code
3443: and dp.period_close_date is null
3444: and dp.set_of_books_id = p_asset_hdr_rec.set_of_books_id ;
3445: