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.GHR_PAY_CALC dependencies on PER_ALL_ASSIGNMENTS_F

Line 1859: FROM per_all_assignments_f

1855:
1856: -- Bug#5120116 created the cursor to get assignment id.
1857: CURSOR c_asg_rec(c_person_id NUMBER, c_effective_date DATE) IS
1858: SELECT assignment_id
1859: FROM per_all_assignments_f
1860: WHERE person_id = c_person_id
1861: AND assignment_type = 'E'
1862: AND c_effective_date between effective_start_date and effective_end_date;
1863:

Line 4192: from per_all_assignments_f paf

4188: c_effective_date IN ghr_pa_requests.effective_date%type)
4189: is
4190: select paf.position_id,
4191: paf.grade_id
4192: from per_all_assignments_f paf
4193: where paf.person_id = c_person_id
4194: and trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date
4195: and paf.primary_flag = 'Y'
4196: and paf.assignment_type <> 'B';