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

Line 4614: from fa_fiscal_year ffy

4610: ,p_period_ctr in number
4611: )
4612: is
4613: select fcp.end_date
4614: from fa_fiscal_year ffy
4615: ,fa_book_controls fbc
4616: ,fa_calendar_periods fcp
4617: ,fa_calendar_types fct
4618: where ffy.fiscal_year_name = fbc.fiscal_year_name

Line 4723: from fa_fiscal_year ffy

4719:
4720: cursor lcu_period_info(p_book_type_code in varchar2,
4721: p_period_ctr in number) is
4722: select fcp.end_date
4723: from fa_fiscal_year ffy
4724: ,fa_book_controls fbc
4725: ,fa_calendar_periods fcp
4726: ,fa_calendar_types fct
4727: where ffy.fiscal_year_name = fbc.fiscal_year_name

Line 4830: from fa_fiscal_year ffy

4826: ,p_period_ctr in number
4827: )
4828: is
4829: select fcp.end_date
4830: from fa_fiscal_year ffy
4831: ,fa_book_controls fbc
4832: ,fa_calendar_periods fcp
4833: ,fa_calendar_types fct
4834: where ffy.fiscal_year_name = fbc.fiscal_year_name

Line 6004: from fa_fiscal_year ffy

6000: select fcp.end_date
6001: ,ffy.fiscal_year
6002: ,fcp.period_num
6003: ,fct.number_per_fiscal_year
6004: from fa_fiscal_year ffy
6005: ,fa_book_controls fbc
6006: ,fa_calendar_periods fcp
6007: ,fa_calendar_types fct
6008: where ffy.fiscal_year_name = fbc.fiscal_year_name

Line 6354: FA_FISCAL_YEAR FAFY

6350: INTO l_imp_exists
6351: FROM
6352: FA_TRANSACTION_HEADERS FATH,
6353: FA_DEPRN_PERIODS FADP,
6354: FA_FISCAL_YEAR FAFY
6355: WHERE FATH.BOOK_TYPE_CODE = p_asset_hdr_rec.BOOK_TYPE_CODE
6356: AND FAFY.FISCAL_YEAR_NAME = l_fiscal_year
6357: AND FATH.ASSET_ID = p_asset_hdr_rec.ASSET_ID
6358: AND FADP.BOOK_TYPE_CODE = FATH.BOOK_TYPE_CODE