DBA Data[Home] [Help]

APPS.FA_CACHE_PKG dependencies on FA_CALENDAR_PERIODS

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

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