APPS.HR_VALID_GRADE_API dependencies on PER_VALID_GRADES

Line 48: l_business_group_id per_valid_grades.business_group_id%TYPE;

44: ) is
45: --
46: -- Declare cursors and local variables
47: --
48: l_business_group_id per_valid_grades.business_group_id%TYPE;
49: l_proc varchar2(72) := g_package||'create_valid_grade';
50:
51: --
52: --

Line 296: update per_valid_grades vg

292: -- job where the end date of the job is earlier than the end
293: -- date of the valid grade.or the previous end dates matched.
294: --
295: --
296: update per_valid_grades vg
297: set vg.date_to =
298: (select least(nvl(p_date_to, to_date('12/31/4712','mm/dd/yyyy')),
299: nvl(g.date_to, to_date('12/31/4712','mm/dd/yyyy')))
300: from per_grades g

Line 332: delete from per_valid_grades vg

328: -- has been made earlier than the start date of the
329: -- valid grade.
330: --
331: --
332: delete from per_valid_grades vg
333: where vg.business_group_id + 0 = p_business_group_id
334: and vg.job_id = p_job_id
335: and vg.date_from > p_date_to;
336: --