The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT b.period_year year,
SUBSTR(b.entered_period_name, 0, 2) quarter,
TO_CHAR(p_input_date, 'MON') month
FROM gl_sets_of_books a, gl_periods b
WHERE a.set_of_books_id = (select set_of_books_id FROM
ozf_sys_parameters_all WHERE org_id = p_org_id)
AND b.period_set_name = a.period_set_name
AND b.period_type=quarter_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.period_name, b.period_num
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=month_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.period_name, b.period_num
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=quarter_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.period_name
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=year_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.period_name
FROM gl_periods b
WHERE b.period_set_name = default_calender
--AND b.period_type=month_type
AND b.period_type=month_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.period_name
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=quarter_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.period_name year
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=year_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.period_num period_num
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=quarter_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT period_name
FROM gl_periods
WHERE end_date =( SELECT start_date -1
FROM gl_periods
WHERE period_name =p_name
AND period_set_name = default_calender)
AND period_set_name = default_calender
AND UPPER(period_type) =p_type;
SELECT b.period_num period_num
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=month_type
AND b.period_name =p_month;
SELECT b.period_num period_num
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=month_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_sets_of_books a, gl_periods b
WHERE a.set_of_books_id = (select set_of_books_id FROM
ozf_sys_parameters_all WHERE org_id = p_org_id)
AND b.period_set_name = a.period_set_name
AND b.period_type=quarter_type
AND TRUNC(v_date) >= TRUNC(b.start_date)
AND TRUNC(v_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=quarter_type
AND TRUNC(v_date) >= TRUNC(b.start_date)
AND TRUNC(v_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_sets_of_books a, gl_periods b
WHERE a.set_of_books_id = (select set_of_books_id FROM
ozf_sys_parameters_all WHERE org_id = p_org_id)
AND b.period_set_name = a.period_set_name
AND b.period_type=year_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=year_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_sets_of_books a, gl_periods b
WHERE a.set_of_books_id = (select set_of_books_id FROM
ozf_sys_parameters_all WHERE org_id = p_org_id)
AND b.period_set_name = a.period_set_name
AND b.period_type=quarter_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=quarter_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_sets_of_books a, gl_periods b
WHERE a.set_of_books_id = (select set_of_books_id FROM
ozf_sys_parameters_all WHERE org_id = p_org_id)
AND b.period_set_name = a.period_set_name
AND b.period_type=month_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=month_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.end_date
FROM gl_sets_of_books a, gl_periods b
WHERE a.set_of_books_id = (select set_of_books_id FROM
ozf_sys_parameters_all WHERE org_id = p_org_id)
AND b.period_set_name = a.period_set_name
AND b.period_type=month_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.end_date
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=month_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.end_date
FROM gl_sets_of_books a, gl_periods b
WHERE a.set_of_books_id = (select set_of_books_id FROM
ozf_sys_parameters_all WHERE org_id = p_org_id)
AND b.period_set_name = a.period_set_name
AND b.period_type=quarter_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.end_date
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=quarter_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.end_date
FROM gl_sets_of_books a, gl_periods b
WHERE a.set_of_books_id = (select set_of_books_id FROM
ozf_sys_parameters_all WHERE org_id = p_org_id)
AND b.period_set_name = a.period_set_name
AND b.period_type=year_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.end_date
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=year_type
AND TRUNC(p_input_date) >= TRUNC(b.start_date)
AND TRUNC(p_input_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=month_type
AND b.period_name =p_period_name;
SELECT b.period_name period_name
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=quarter_type
AND TRUNC(l_start_date) >= TRUNC(b.start_date)
AND TRUNC(l_start_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=month_type
AND b.period_name =p_period_name;
SELECT b.period_name period_name
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=year_type
AND TRUNC(l_start_date) >= TRUNC(b.start_date)
AND TRUNC(l_start_date) <= TRUNC(b.end_date);
SELECT b.start_date
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=quarter_type
AND b.period_name =p_period_name;
SELECT b.period_name period_name
FROM gl_periods b
WHERE b.period_set_name = default_calender
AND b.period_type=year_type
AND TRUNC(l_start_date) >= TRUNC(b.start_date)
AND TRUNC(l_start_date) <= TRUNC(b.end_date);