The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT period_name
INTO low_period_name
FROM gl_date_period_map
WHERE period_set_name = calendar_name
AND period_type = get_num_periods_in_date_range.period_type
AND accounting_date = start_date;
SELECT period_name
INTO high_period_name
FROM gl_date_period_map
WHERE period_set_name = calendar_name
AND period_type = get_num_periods_in_date_range.period_type
AND accounting_date = end_date;
SELECT min(accounting_date)
INTO unmapped_date
FROM gl_date_period_map
WHERE period_set_name = calendar_name
AND period_type = get_num_periods_in_date_range.period_type
AND accounting_date between start_date and end_date
AND period_name = 'NOT ASSIGNED';
SELECT count(*)
INTO num_periods
FROM gl_periods
WHERE period_set_name = calendar_name
AND period_type = get_num_periods_in_date_range.period_type
AND adjustment_period_flag = 'N'
AND start_date <= get_num_periods_in_date_range.end_date
AND end_date >= get_num_periods_in_date_range.start_date;