The following lines contain the word 'select', 'insert', 'update' or 'delete':
cursor c1 is select name
from per_grades
where p_grade_id = grade_id;
cursor c1 is select per_valid_grades_s.nextval
from sys.dual;
select null
from per_valid_grades vg
where ((p_rowid is not null and
rowidtochar(rowid) <> p_rowid)
or p_rowid is null)
and vg.business_group_id + 0 = p_business_group_id
and vg.job_id = p_job_id
and vg.grade_id = p_grade_id
-- Bug 3338072 Start
and (p_date_from between
vg.date_from and nvl(vg.date_to,hr_api.g_eot) or
p_date_to between
vg.date_from and nvl(vg.date_to,hr_api.g_eot));
cursor csr_grade_date is select g.date_from
from per_grades g
where g.grade_id = p_grade_id
and p_date_from < g.date_from;
cursor csr_grade_date is select nvl(g.date_to, p_end_of_time)
from per_grades g
where g.grade_id = p_grade_id
and nvl(p_date_to, p_end_of_time) >
nvl(g.date_to, p_end_of_time);