eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_JOB_API dependencies on PER_VALID_GRADES

Line 87: from per_valid_grades vgr

83: vgr.valid_grade_id valid_grade_id
84: ,vgr.object_version_number object_version_number
85: ,vgr.date_from date_from
86: ,vgr.date_to date_to
87: from per_valid_grades vgr
88: where vgr.job_id = p_job_id;
89: --
90: begin
91: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 1811: update per_valid_grades vg

1807: -- job where the end date of the job is earlier than the end
1808: -- date of the valid grade.or the previous end dates matched.
1809: --
1810: --
1811: update per_valid_grades vg
1812: set vg.date_to =
1813: (select least(nvl(p_date_to, p_end_of_time),
1814: nvl(g.date_to, p_end_of_time))
1815: from per_grades g

Line 1846: delete from per_valid_grades vg

1842: -- has been made earlier than the start date of the
1843: -- valid grade.
1844: --
1845: --
1846: delete from per_valid_grades vg
1847: where vg.business_group_id + 0 = p_business_group_id
1848: and vg.job_id = p_job_id
1849: and vg.date_from > p_date_to;
1850: --