APPS.PER_ES_CREATE_EMPLOYEE dependencies on HR_LOOKUPS

Line 17: select lookup_code from hr_lookups where

13: ,p_per_information3 VARCHAR2
14: ) is
15:
16: CURSOR get_lookup_type(p_per_information2 varchar2) is
17: select lookup_code from hr_lookups where
18: lookup_type='ES_IDENTIFIER_TYPE'
19: and lookup_code=p_per_information2;
20:
21: l_identifier_type hr_lookups.lookup_code%TYPE;

Line 21: l_identifier_type hr_lookups.lookup_code%TYPE;

17: select lookup_code from hr_lookups where
18: lookup_type='ES_IDENTIFIER_TYPE'
19: and lookup_code=p_per_information2;
20:
21: l_identifier_type hr_lookups.lookup_code%TYPE;
22: l_identifier_value VARCHAR2(10);
23: l_validate_profile VARCHAR2(20);
24: l_proc VARCHAR2(72) := g_package||'CREATE_ES_EMPLOYEE';
25: l_national_identifier per_all_people_f.national_identifier%TYPE;