DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 1925: from per_all_assignments_f asg

1921: -- to prevent the wrong assignment being picked up.
1922:
1923: cursor c_get_primary_assignment is
1924: select asg.assignment_id
1925: from per_all_assignments_f asg
1926: where asg.person_id = p_person_id
1927: and p_effective_date between
1928: asg.effective_start_date and asg.effective_end_date
1929: and asg.primary_flag = 'Y'

Line 2014: ,per_all_assignments_f asg

2010: select distinct pee.element_entry_id
2011: ,pee.effective_start_date
2012: ,pee.effective_end_date
2013: from per_absence_attendances abs
2014: ,per_all_assignments_f asg
2015: ,per_absence_attendance_types abt
2016: ,pay_input_values_f piv
2017: ,pay_element_types_f pet
2018: ,pay_element_links_f pel