DBA Data[Home] [Help]

APPS.FA_ADJUSTMENTS_T_PKG dependencies on FA_FISCAL_YEAR

Line 317: , fa_fiscal_year fy

313:
314: select cp.period_name name
315: into l_name
316: from fa_book_controls bc
317: , fa_fiscal_year fy
318: , fa_calendar_types ct
319: , fa_calendar_periods cp
320: , fa_adjustments_t fat
321: where bc.book_type_code = i.book

Line 376: , fa_fiscal_year fy

372: into l_name
373: , l_pctr
374: from fa_books bks
375: , fa_book_controls bc
376: , fa_fiscal_year fy
377: , fa_calendar_types ct
378: , fa_calendar_periods cp
379: where bc.book_type_code = i.book
380: and bks.asset_id = i.aid

Line 393: from fa_fiscal_year

389: decode(mod(bks.period_counter_fully_reserved,ct.number_per_fiscal_year)
390: , 0 , (bks.period_counter_fully_reserved-1)/ct.number_per_fiscal_year
391: , bks.period_counter_fully_reserved/ct.number_per_fiscal_year))
392: , 1, (select min(fiscal_year)
393: from fa_fiscal_year
394: where fiscal_year_name = ct.fiscal_year_name
395: and start_date >= to_date('01/04/2007', 'DD/MM/RRRR'))
396: /* Bug 7229538. The existing Hard coded year 2007 is removed.
397: Because it is not guarantee that fiscal year always starts from 01-Apr-2007.