DBA Data[Home] [Help]

APPS.HR_SA_GET_PERSON_DETAILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 14: ,per_all_assignments_f ASSIGN

10: l_Effective_Date Date) IS
11: select a.meaning
12: from per_all_people_f PEOPLE
13: ,hr_lookups a
14: ,per_all_assignments_f ASSIGN
15: ,per_shared_types SHTYPE
16: where l_effective_date between ASSIGN.effective_start_date
17: and ASSIGN.effective_end_date
18: and l_effective_date BETWEEN PEOPLE.effective_start_date