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_CALENDAR_PERIODS

Line 262: , fa_calendar_periods cp

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
266: and c_start_date between cp.start_date and cp.end_date;

Line 1914: , fa_calendar_periods cp

1910: from fa_transaction_headers th
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

Line 2063: , fa_calendar_periods cp

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
2066: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2067: and ct.calendar_type = cp.calendar_type