DBA Data[Home] [Help]

APPS.HR_VALID_GRADE_API dependencies on PER_GRADES

Line 63: from per_grades gra

59:
60:
61: cursor csr_bus_grp is
62: select gra.business_group_id
63: from per_grades gra
64: where gra.grade_id = p_grade_id;
65: --
66: begin
67: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 300: from per_grades g

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
301: where g.grade_id = vg.grade_id
302: and g.business_group_id + 0 = p_business_group_id)
303: where vg.business_group_id + 0 = p_business_group_id
304: and vg.job_id = p_job_id