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 97: l_dept hr_lookups.meaning%TYPE;

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

Line 98: l_dept_code hr_lookups.lookup_code%TYPE;

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

Line 108: from hr_lookups hl

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