DBA Data[Home] [Help]

APPS.HR_SA_GET_PERSON_DETAILS dependencies on PER_ALL_PEOPLE_F

Line 12: from per_all_people_f PEOPLE

8:
9: CURSOR csr_Nationality_Group (l_Assignment_Id Number,
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

Line 52: from per_all_people_f PEOPLE

48:
49: CURSOR csr_Nationality_Group (l_Person_Id Number,
50: l_Effective_Date Date) IS
51: select a.meaning
52: from per_all_people_f PEOPLE
53: ,hr_lookups a
54: ,per_shared_types SHTYPE
55: where PEOPLE.person_id = l_person_id
56: and l_effective_date BETWEEN PEOPLE.effective_start_date