APPS.HR_SA_GET_PERSON_DETAILS dependencies on HR_LOOKUPS

Line 7: l_Nationality_Group HR_LOOKUPS.MEANING%TYPE;

3:
4: Function ASG_NATIONALITY_GROUP (p_Assignment_Id Number,
5: p_Effective_Date Date) return Varchar2
6: IS
7: l_Nationality_Group HR_LOOKUPS.MEANING%TYPE;
8:
9: CURSOR csr_Nationality_Group (l_Assignment_Id Number,
10: l_Effective_Date Date) IS
11: select a.meaning

Line 13: ,hr_lookups a

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
17: and ASSIGN.effective_end_date

Line 47: l_Nationality_Group HR_LOOKUPS.MEANING%TYPE;

43:
44: Function PER_NATIONALITY_GROUP (p_Person_Id Number,
45: p_Effective_Date Date) return Varchar2
46: IS
47: l_Nationality_Group HR_LOOKUPS.MEANING%TYPE;
48:
49: CURSOR csr_Nationality_Group (l_Person_Id Number,
50: l_Effective_Date Date) IS
51: select a.meaning

Line 53: ,hr_lookups a

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
57: AND PEOPLE.effective_end_date