APPS.PER_FR_PEOPLE_LEG_HOOK dependencies on HR_LOOKUPS

Line 31: l_dept hr_lookups.meaning%TYPE;

27: ,p_hire_date DATE
28: ) IS
29:
30: l_proc VARCHAR2(200) := g_package||'check_regn_entry_ins';
31: l_dept hr_lookups.meaning%TYPE;
32: l_dept_code hr_lookups.lookup_code%TYPE;
33:
34: CURSOR cur_dept IS
35: select hl.meaning, hl.lookup_code

Line 32: l_dept_code hr_lookups.lookup_code%TYPE;

28: ) IS
29:
30: l_proc VARCHAR2(200) := g_package||'check_regn_entry_ins';
31: l_dept hr_lookups.meaning%TYPE;
32: l_dept_code hr_lookups.lookup_code%TYPE;
33:
34: CURSOR cur_dept IS
35: select hl.meaning, hl.lookup_code
36: from hr_lookups hl

Line 36: from hr_lookups hl

32: l_dept_code hr_lookups.lookup_code%TYPE;
33:
34: CURSOR cur_dept IS
35: select hl.meaning, hl.lookup_code
36: from hr_lookups hl
37: where hl.lookup_type = 'FR_DEPARTMENT'
38: and p_hire_date
39: between nvl(hl.start_date_active,p_hire_date)
40: and nvl(hl.end_date_active,p_hire_date)

Line 93: l_dept hr_lookups.meaning%TYPE;

89: ,p_person_id NUMBER
90: ) IS
91:
92: l_proc VARCHAR2(200) := g_package||'check_regn_entry_upd';
93: l_dept hr_lookups.meaning%TYPE;
94: l_dept_code hr_lookups.lookup_code%TYPE;
95: l_old_region_of_birth per_all_people_f.region_of_birth%TYPE;
96: l_old_country_of_birth per_all_people_f.country_of_birth%TYPE;
97: l_old_information10 per_all_people_f.per_information10%TYPE;

Line 94: l_dept_code hr_lookups.lookup_code%TYPE;

90: ) IS
91:
92: l_proc VARCHAR2(200) := g_package||'check_regn_entry_upd';
93: l_dept hr_lookups.meaning%TYPE;
94: l_dept_code hr_lookups.lookup_code%TYPE;
95: l_old_region_of_birth per_all_people_f.region_of_birth%TYPE;
96: l_old_country_of_birth per_all_people_f.country_of_birth%TYPE;
97: l_old_information10 per_all_people_f.per_information10%TYPE;
98: l_use_region_of_birth per_all_people_f.region_of_birth%TYPE;

Line 104: from hr_lookups hl

100: l_use_information10 per_all_people_f.per_information10%TYPE;
101:
102: CURSOR cur_dept IS
103: select hl.meaning, hl.lookup_code
104: from hr_lookups hl
105: where hl.lookup_type = 'FR_DEPARTMENT'
106: and p_effective_date
107: between nvl(hl.start_date_active,p_effective_date)
108: and nvl(hl.end_date_active,p_effective_date)