APPS.PER_ES_CREATE_APPLICANT dependencies on HR_LOOKUPS

Line 18: FROM hr_lookups

14: ) is
15:
16: CURSOR get_lookup_type(p_per_information2 varchar2) is
17: SELECT lookup_code
18: FROM hr_lookups
19: WHERE lookup_type='ES_IDENTIFIER_TYPE'
20: AND lookup_code=p_per_information2;
21:
22:

Line 23: l_identifier_type hr_lookups.lookup_code%TYPE;

19: WHERE lookup_type='ES_IDENTIFIER_TYPE'
20: AND lookup_code=p_per_information2;
21:
22:
23: l_identifier_type hr_lookups.lookup_code%TYPE;
24: l_identifier_value VARCHAR2(10);
25: l_proc VARCHAR2(72) := g_package||'CREATE_ES_APPLICANT';
26: l_national_identifier per_all_people_f.national_identifier%TYPE;
27: BEGIN