93: END IF;
94:
95: SELECT count(*)
96: INTO num_periods 97: FROM gl_periods 98: WHERE period_set_name = calendar_name
99: AND period_type = get_num_periods_in_date_range.period_type
100: AND adjustment_period_flag = 'N'
101: AND start_date <= get_num_periods_in_date_range.end_date