APPS.PER_ES_UPDATE_PERSON dependencies on PER_ALL_PEOPLE_F

Line 34: FROM per_all_people_f

30: --
31: CURSOR get_identifier_type (p_person_id VARCHAR2
32: ,p_effective_date DATE) IS
33: SELECT per_information2
34: FROM per_all_people_f
35: WHERE person_id=p_person_id
36: AND p_effective_date BETWEEN effective_start_date
37: AND effective_end_date;
38:

Line 42: FROM per_all_people_f

38:
39: CURSOR get_identifier_value (p_person_id VARCHAR2
40: ,p_effective_date DATE) IS
41: SELECT p_per_information3
42: FROM per_all_people_f
43: WHERE person_id=p_person_id
44: AND p_effective_date BETWEEN effective_start_date
45: AND effective_end_date;
46:

Line 50: FROM per_all_people_f

46:
47: CURSOR get_national_ident (p_person_id VARCHAR2
48: ,p_effective_date DATE) IS
49: SELECT national_identifier
50: FROM per_all_people_f
51: WHERE person_id=p_person_id
52: AND p_effective_date BETWEEN effective_start_date
53: AND effective_end_date;
54: --

Line 62: l_identifier_value per_all_people_f.per_information3%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);
66: BEGIN

Line 64: l_national_identifier per_all_people_f.national_identifier%TYPE;

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);
66: BEGIN
67: --
68: -- Added for GSI Bug 5472781