APPS.PER_ES_UPDATE_PERSON dependencies on PER_PERSON_TYPES

Line 22: FROM per_person_types ppt

18:
19: CURSOR csr_person_type IS
20: SELECT 'Y' FROM DUAL
21: WHERE EXISTS(SELECT ppt.system_person_type
22: FROM per_person_types ppt
23: ,per_person_type_usages_f ptu
24: ,fnd_sessions ses
25: WHERE ptu.person_id = p_person_id
26: AND ppt.person_type_id = ptu.person_type_id

Line 56: l_person_type per_person_types.system_person_type%TYPE;

52: AND p_effective_date BETWEEN effective_start_date
53: AND effective_end_date;
54: --
55:
56: l_person_type per_person_types.system_person_type%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: --

Line 57: l_seed_person_type per_person_types.seeded_person_type_key%TYPE;

53: AND effective_end_date;
54: --
55:
56: l_person_type per_person_types.system_person_type%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;