APPS.PER_ES_UPDATE_PERSON dependencies on HR_LOOKUPS

Line 15: FROM hr_lookups

11: ,p_per_information3 VARCHAR2) IS
12:
13: CURSOR get_lookup_type(p_per_information2 VARCHAR2) IS
14: SELECT lookup_code
15: FROM hr_lookups
16: WHERE lookup_type='ES_IDENTIFIER_TYPE'
17: AND lookup_code=p_per_information2;
18:
19: CURSOR csr_person_type IS

Line 61: l_identifier_type hr_lookups.lookup_code%TYPE;

57: l_seed_person_type per_person_types.seeded_person_type_key%TYPE;
58: l_chk VARCHAR2(1);
59: l_chk_identifier VARCHAR2(1);
60: --
61: l_identifier_type hr_lookups.lookup_code%TYPE;
62: l_identifier_value per_all_people_f.per_information3%TYPE;
63: l_proc VARCHAR2(72);
64: l_national_identifier per_all_people_f.national_identifier%TYPE;
65: l_check_val VARCHAR2(1);