DBA Data[Home] [Help]

APPS.FA_CACHE_PKG dependencies on FA_CALENDAR_PERIODS

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 1004: FROM fa_calendar_periods cp,

1000: fy.fiscal_year
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