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

Line 152: from fa_fiscal_year fy

148: CURSOR c_get_period_rec IS
149: select cp.period_name period_name
150: , cp.period_num period_num
151: , fy.fiscal_year fiscal_year
152: from fa_fiscal_year fy
153: , fa_calendar_periods cp
154: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
155: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
156: and cp.start_date between fy.start_date and fy.end_date

Line 1084: from fa_calendar_periods cp, fa_fiscal_year fy

1080: , cp.start_date
1081: into h_start_per_num
1082: , h_start_per_fy
1083: , l_cp_start_date
1084: from fa_calendar_periods cp, fa_fiscal_year fy
1085: where cp.period_name = X_start_per
1086: and cp.calendar_type = h_calendar_type
1087: and cp.start_date >= fy.start_date
1088: and cp.end_date <= fy.end_date