DBA Data[Home] [Help]

APPS.HR_CANCEL_HIRE_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 39: ,per_all_assignments_f paa

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
43: AND paa.person_id = pos.person_id

Line 63: ,per_all_assignments_f paa

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
67: AND paa.person_id = pos.person_id