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_PROCESS_IMPAIRMENT_PKG dependencies on FA_FISCAL_YEAR

Line 73: , fa_fiscal_year fy

69: , cp.end_date calendar_period_close_date
70: , cp.period_num period_num
71: , fy.fiscal_year fiscal_year
72: from fa_book_controls bc
73: , fa_fiscal_year fy
74: , fa_calendar_types ct
75: , fa_calendar_periods cp
76: where bc.book_type_code = p_book_type_code
77: and bc.deprn_calendar = ct.calendar_type

Line 93: , fa_fiscal_year fy

89: , cp.period_num period_num
90: , fy.fiscal_year fiscal_year
91: from fa_book_controls bc
92: , fa_mc_book_controls mbc
93: , fa_fiscal_year fy
94: , fa_calendar_types ct
95: , fa_calendar_periods cp
96: where bc.book_type_code = p_book_type_code
97: and mbc.book_type_code = p_book_type_code

Line 305: from fa_fiscal_year fy

301: , imp.REQUEST_ID = l_request_id
302: , imp.PERIOD_COUNTER_IMPAIRED =
303: (select nvl(imp.PERIOD_COUNTER_IMPAIRED,
304: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM)
305: from fa_fiscal_year fy
306: , fa_calendar_types ct
307: , fa_calendar_periods cp
308: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
309: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name

Line 327: from fa_fiscal_year fy

323: , imp.REQUEST_ID = l_request_id
324: , imp.PERIOD_COUNTER_IMPAIRED =
325: (select nvl(imp.PERIOD_COUNTER_IMPAIRED,
326: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM)
327: from fa_fiscal_year fy
328: , fa_calendar_types ct
329: , fa_calendar_periods cp
330: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
331: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name