SELECT period_year f_year, period_num month_No, entered_period_name f_month, quarter_num f_qtr, TO_CHAR(start_date,'mm/dd/yyyy') f_start, TO_CHAR(end_date,'mm/dd/yyyy') f_end, (end_date - start_date)+1 fm_days, SUM((end_date - start_date)+1) OVER (ORDER BY period_num) cfy_days, adjustment_period_flag FROM gl_periods Where period_set_name = 'Fiscal Calendar' -- value may be different AND period_year = &i_yyyy;
72789