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_CANCEL_HIRE_API dependencies on PER_PERIODS_OF_SERVICE

Line 38: FROM per_periods_of_service pos

34: SELECT DISTINCT
35: paa.business_group_id
36: ,pos.period_of_service_id
37: ,pos.date_start
38: FROM per_periods_of_service pos
39: ,per_all_assignments_f paa
40: WHERE paa.person_id = p_person_id
41: AND p_effective_date BETWEEN
42: paa.effective_start_date AND paa.effective_end_date

Line 49: FROM per_periods_of_service pos2

45: -- 115.3 (START)
46: --
47: AND pos.date_start IN
48: (SELECT MAX(pos2.date_start)
49: FROM per_periods_of_service pos2
50: WHERE pos2.person_id = p_person_id)
51: --
52: -- 115.3 (END)
53: --

Line 62: FROM per_periods_of_service pos

58: SELECT DISTINCT
59: paa.business_group_id
60: ,pos.period_of_service_id
61: ,pos.date_start
62: FROM per_periods_of_service pos
63: ,per_all_assignments_f paa
64: WHERE paa.person_id = p_person_id
65: AND p_effective_date BETWEEN
66: paa.effective_start_date AND paa.effective_end_date