APPS.FA_CACHE_PKG dependencies on FA_FISCAL_YEAR

Line 655: FROM fa_calendar_periods cp, fa_fiscal_year fy

651: (cp.end_date + 1 - cp.start_date) /
652: (fy.end_date + 1 - fy.start_date)),
653: to_number (to_char (cp.start_date, 'J')),
654: to_number (to_char (cp.end_date, 'J'))
655: FROM fa_calendar_periods cp, fa_fiscal_year fy
656: WHERE fy.fiscal_year = X_fy
657: AND fy.fiscal_year_name = h_fiscal_year_name
658: AND cp.calendar_type = X_calendar
659: AND cp.start_date BETWEEN fy.start_date AND fy.end_date

Line 1005: fa_fiscal_year fy

1001: INTO fazccp_record.start_jdate,
1002: fazccp_record.period_num,
1003: fazccp_record.fiscal_year
1004: FROM fa_calendar_periods cp,
1005: fa_fiscal_year fy
1006: WHERE fy.fiscal_year_name = X_target_fy_name
1007: AND cp.calendar_type = X_target_calendar
1008: AND x_target_date between fy.start_date and fy.end_date
1009: AND cp.start_date between fy.start_date and fy.end_date

Line 2102: FROM fa_fiscal_year

2098: end if;
2099:
2100: SELECT *
2101: INTO fazcfy_record
2102: FROM fa_fiscal_year
2103: WHERE fiscal_year_name = X_fiscal_year_name
2104: AND fiscal_year = X_fiscal_year;
2105:
2106: fazcfy_table(fazcfy_table.count + 1):= fazcfy_record;