DBA Data[Home] [Help]

APPS.FA_AMORT_PVT dependencies on FA_DEPRN_PERIODS_MRC_V

Line 142: from fa_deprn_periods_mrc_v

138: , calendar_period_open_date
139: , calendar_period_close_date
140: , fiscal_year
141: , period_num
142: from fa_deprn_periods_mrc_v
143: where book_type_code = p_book_type_code
144: and to_date (to_char (p_jdate), 'J') between calendar_period_open_date
145: and calendar_period_close_date;
146:

Line 3415: from fa_deprn_periods_mrc_v dp

3411: and dp.period_close_date is null;
3412:
3413: CURSOR c_get_current_period_mrc IS
3414: select dp.period_counter
3415: from fa_deprn_periods_mrc_v dp
3416: where dp.book_type_code = p_asset_hdr_rec.book_type_code
3417: and dp.period_close_date is null;
3418:
3419: