eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_IMPAIRMENT_PREV_PVT dependencies on FA_FISCAL_YEAR

Line 261: from fa_fiscal_year fy

257:
258: CURSOR c_get_period_rec (c_start_date date) IS
259: select cp.period_num
260: , fy.fiscal_year
261: from fa_fiscal_year fy
262: , fa_calendar_periods cp
263: where cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
264: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
265: and cp.start_date between fy.start_date and fy.end_date

Line 1915: , fa_fiscal_year fy

1911: , fa_books inbk
1912: , fa_books outbk
1913: , fa_calendar_types ct
1914: , fa_calendar_periods cp
1915: , fa_fiscal_year fy
1916: where th.asset_id = p_asset_id
1917: and th.book_type_code = p_book_type_code
1918: and inbk.asset_id = th.asset_id
1919: and inbk.asset_id = outbk.asset_id(+)

Line 2061: from fa_fiscal_year fy

2057: , 0 eofy_formula_factor
2058: , 0 eofy_reserve
2059: , 0 eop_adj_cost
2060: , 0 bonus_rate
2061: from fa_fiscal_year fy
2062: , fa_calendar_types ct
2063: , fa_calendar_periods cp
2064: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
2065: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name