The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT calendar_code, calendar_exception_set_id
FROM MTL_PARAMETERS
WHERE organization_id = org_id;
SELECT shift_num
FROM BOM_SHIFT_DATES
WHERE calendar_code = cal_code AND
exception_set_id = nvl(except_set, -1) AND
shift_date = cur_date AND
shift_num NOT IN (SELECT shift_num
FROM BOM_SHIFT_TIMES
WHERE calendar_code = cal_code AND
cur_seconds not between FROM_TIME and TO_TIME) AND
seq_num IS NOT NULL;
SELECT seq_num
FROM BOM_CAL_WEEK_START_DATES
WHERE calendar_code = cal_code AND
exception_set_id = nvl(except_set, -1) AND
cur_date BETWEEN week_start_date AND next_date;
SELECT period_sequence_num
FROM BOM_PERIOD_START_DATES
WHERE calendar_code = cal_code AND
exception_set_id = nvl(except_set, -1) AND
cur_date between period_start_date and next_date;
SELECT period_num
FROM org_acct_periods
WHERE organization_id = org_id
AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(cur_date,org_id) BETWEEN period_start_date AND
schedule_close_date;
SELECT period_set_name
FROM org_acct_periods
WHERE organization_id = org_id;
SELECT quarter_num
FROM gl_periods
WHERE period_set_name = set_name AND
cur_date BETWEEN quarter_start_date AND
add_months(quarter_start_date, 3);
--shifts can overlap, so select can return multiple rows
WHILE current_shifts%FOUND LOOP
ret_val := Check_Between(cur_val, from_val, to_val);
SELECT sysdate
FROM DUAL;