APPS.PER_VALID_GRADES_PKG dependencies on PER_GRADES

Line 8: from per_grades_vl -- Bug 13538388

4: procedure get_grade(p_grade_id in number,
5: p_grade in out nocopy varchar2) is
6: --
7: cursor c1 is select name
8: from per_grades_vl -- Bug 13538388
9: where p_grade_id = grade_id;
10: --
11: begin
12: --

Line 104: from per_grades g

100: PROCEDURE check_date_from(p_grade_id number,
101: p_date_from date) is
102: --
103: cursor csr_grade_date is select g.date_from
104: from per_grades g
105: where g.grade_id = p_grade_id
106: and p_date_from < g.date_from;
107: --
108: g_dummy_date date;

Line 136: from per_grades g

132: p_date_to date,
133: p_end_of_time date) is
134: --
135: cursor csr_grade_date is select nvl(g.date_to, p_end_of_time)
136: from per_grades g
137: where g.grade_id = p_grade_id
138: and nvl(p_date_to, p_end_of_time) >
139: nvl(g.date_to, p_end_of_time);
140: --

Line 144: -- Check that date_to of valid grade is after date_to in per_grades

140: --
141: g_dummy_date date;
142: v_date_greater boolean := FALSE;
143: --
144: -- Check that date_to of valid grade is after date_to in per_grades
145: --
146: begin
147: --
148: open csr_grade_date;