APPS.PER_VALID_GRADES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

cursor c1 is select name
        from   per_grades_vl -- Bug 13538388
        where p_grade_id = grade_id;

Line: 30

cursor c1 is select per_valid_grades_s.nextval
        from sys.dual;

Line: 63

   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));

Line: 103

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;

Line: 135

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);