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_CALENDAR_PERIODS

Line 159: , fa_calendar_periods cp

155: select cp.period_name period_name
156: , cp.period_num period_num
157: , fy.fiscal_year fiscal_year
158: from fa_fiscal_year fy
159: , fa_calendar_periods cp
160: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
161: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
162: and cp.start_date between fy.start_date and fy.end_date
163: and l_st_period_counter <= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

Line 1167: from fa_calendar_periods cp, fa_fiscal_year fy

1163: , cp.start_date
1164: into h_start_per_num
1165: , h_start_per_fy
1166: , l_cp_start_date
1167: from fa_calendar_periods cp, fa_fiscal_year fy
1168: where cp.period_name = X_start_per
1169: and cp.calendar_type = h_calendar_type
1170: and cp.start_date >= fy.start_date
1171: and cp.end_date <= fy.end_date

Line 1183: FROM fa_calendar_periods cp

1179: SELECT cp.period_num
1180: , fy.fiscal_year
1181: into dpr_in.p_cl_begin
1182: , dpr_in.y_begin
1183: FROM fa_calendar_periods cp
1184: , fa_fiscal_year fy
1185: , fa_book_controls fb
1186: , fa_books fk
1187: WHERE cp.calendar_type = fb.deprn_calendar

Line 1204: , fa_calendar_periods cp

1200: (
1201: Select cp.period_num period_num,
1202: fy.fiscal_year fiscal_year
1203: From fa_fiscal_year fy
1204: , fa_calendar_periods cp
1205: WHERE cp.calendar_type = h_calendar_type
1206: AND cp.start_date >= fy.start_date
1207: AND cp.end_date <= fy.end_date
1208: AND fy.fiscal_year_name = h_fy_name