DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 2513: from per_all_assignments_f asg

2509: -- to prevent the wrong assignment being picked up.
2510:
2511: cursor c_get_primary_assignment is
2512: select asg.assignment_id
2513: from per_all_assignments_f asg
2514: where asg.person_id = p_person_id
2515: and p_effective_date between
2516: asg.effective_start_date and asg.effective_end_date
2517: and asg.primary_flag = 'Y'

Line 2602: ,per_all_assignments_f asg

2598: select distinct pee.element_entry_id
2599: ,pee.effective_start_date
2600: ,pee.effective_end_date
2601: from per_absence_attendances abs
2602: ,per_all_assignments_f asg
2603: ,per_absence_attendance_types abt
2604: ,pay_input_values_f piv
2605: ,pay_element_types_f pet
2606: ,pay_element_links_f pel