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

Line 279: FROM per_all_assignments_f

275: ( p_person_id per_all_people_f.person_id%TYPE
276: , p_check_date date)
277: IS
278: SELECT Min(effective_start_date) + 1
279: FROM per_all_assignments_f
280: WHERE person_id = p_person_id
281: AND effective_start_date > p_check_date;
282: BEGIN
283: hr_utility.set_location('Entering ' || l_proc, 10);

Line 308: FROM per_all_assignments_f

304: ( p_person_id per_all_people_f.person_id%TYPE
305: , p_check_date date)
306: IS
307: SELECT Max(effective_start_date) + 1
308: FROM per_all_assignments_f
309: WHERE person_id = p_person_id
310: AND effective_start_date < p_check_date;
311: BEGIN
312: hr_utility.set_location('Entering ' || l_proc, 10);

Line 525: FROM per_all_assignments_f paf

521: CURSOR csr_Get_Accepted_Asg
522: (p_person_id per_all_people_f.person_id%TYPE)
523: IS
524: SELECT min(effective_start_date) + 1
525: FROM per_all_assignments_f paf
526: , per_assignment_status_types past
527: WHERE person_id = p_person_id
528: AND paf.assignment_status_type_id = past.assignment_status_type_id
529: AND past.per_system_status = 'ACCEPTED';