APPS.FA_CACHE_PKG dependencies on FA_FISCAL_YEAR

Line 918: FROM fa_calendar_periods cp, fa_fiscal_year fy

914: (cp.end_date + 1 - cp.start_date) /
915: (fy.end_date + 1 - fy.start_date)),
916: to_number (to_char (cp.start_date, 'J')),
917: to_number (to_char (cp.end_date, 'J'))
918: FROM fa_calendar_periods cp, fa_fiscal_year fy
919: WHERE fy.fiscal_year = X_fy
920: AND fy.fiscal_year_name = h_fiscal_year_name
921: AND cp.calendar_type = X_calendar
922: AND cp.start_date BETWEEN fy.start_date AND fy.end_date

Line 1274: fa_fiscal_year fy

1270: INTO fazccp_record.start_jdate,
1271: fazccp_record.period_num,
1272: fazccp_record.fiscal_year
1273: FROM fa_calendar_periods cp,
1274: fa_fiscal_year fy
1275: WHERE fy.fiscal_year_name = X_target_fy_name
1276: AND cp.calendar_type = X_target_calendar
1277: AND x_target_date between fy.start_date and fy.end_date
1278: AND cp.start_date between fy.start_date and fy.end_date

Line 2382: FROM fa_fiscal_year

2378: end if;
2379:
2380: SELECT *
2381: INTO fazcfy_record
2382: FROM fa_fiscal_year
2383: WHERE fiscal_year_name = X_fiscal_year_name
2384: AND fiscal_year = X_fiscal_year;
2385:
2386: fazcfy_table(fazcfy_table.count + 1):= fazcfy_record;