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: -- Bug 10282503
67: l_pos_date_effective date;

Line 318: from per_grades g

314: update per_valid_grades vg
315: set vg.date_to =
316: (select least(nvl(p_date_to, to_date('12/31/4712','mm/dd/yyyy')),
317: nvl(g.date_to, to_date('12/31/4712','mm/dd/yyyy')))
318: from per_grades g
319: where g.grade_id = vg.grade_id
320: and g.business_group_id + 0 = p_business_group_id)
321: where vg.business_group_id + 0 = p_business_group_id
322: and vg.job_id = p_job_id