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_ALL_ASSIGNMENTS_F

Line 78: ,per_all_assignments_f paa

74: paa.business_group_id
75: ,pos.period_of_service_id
76: ,pos.date_start
77: FROM per_periods_of_service pos
78: ,per_all_assignments_f paa
79: WHERE paa.person_id = p_person_id
80: AND p_effective_date BETWEEN
81: paa.effective_start_date AND paa.effective_end_date
82: AND paa.person_id = pos.person_id

Line 102: ,per_all_assignments_f paa

98: paa.business_group_id
99: ,pos.period_of_service_id
100: ,pos.date_start
101: FROM per_periods_of_service pos
102: ,per_all_assignments_f paa
103: WHERE paa.person_id = p_person_id
104: AND p_effective_date BETWEEN
105: paa.effective_start_date AND paa.effective_end_date
106: AND paa.person_id = pos.person_id

Line 219: from per_all_assignments_f

215: select 'exist'
216: from per_pay_proposals
217: where assignment_id in (
218: select distinct (assignment_id)
219: from per_all_assignments_f
220: where person_id= p_person_id
221: and assignment_type ='E'
222: and l_efd -1 between effective_start_date and effective_end_date
223: and primary_flag='Y'