APPS.PER_PL_UPDATE_PERSON dependencies on PER_PERSON_TYPES

Line 22: l_contact_type_key per_person_types.seeded_person_type_key%TYPE;

18: ,p_per_information6 VARCHAR2
19: ,p_per_information7 VARCHAR2
20: ,p_per_information8 VARCHAR2) is
21:
22: l_contact_type_key per_person_types.seeded_person_type_key%TYPE;
23: l_emp_type_key per_person_types.seeded_person_type_key%TYPE;
24: l_app_type_key per_person_types.seeded_person_type_key%TYPE;
25: l_cwk_type_key per_person_types.seeded_person_type_key%TYPE;
26: l_chk varchar2(1);

Line 23: l_emp_type_key per_person_types.seeded_person_type_key%TYPE;

19: ,p_per_information7 VARCHAR2
20: ,p_per_information8 VARCHAR2) is
21:
22: l_contact_type_key per_person_types.seeded_person_type_key%TYPE;
23: l_emp_type_key per_person_types.seeded_person_type_key%TYPE;
24: l_app_type_key per_person_types.seeded_person_type_key%TYPE;
25: l_cwk_type_key per_person_types.seeded_person_type_key%TYPE;
26: l_chk varchar2(1);
27: l_con varchar2(1);

Line 24: l_app_type_key per_person_types.seeded_person_type_key%TYPE;

20: ,p_per_information8 VARCHAR2) is
21:
22: l_contact_type_key per_person_types.seeded_person_type_key%TYPE;
23: l_emp_type_key per_person_types.seeded_person_type_key%TYPE;
24: l_app_type_key per_person_types.seeded_person_type_key%TYPE;
25: l_cwk_type_key per_person_types.seeded_person_type_key%TYPE;
26: l_chk varchar2(1);
27: l_con varchar2(1);
28: l_app varchar2(1);

Line 25: l_cwk_type_key per_person_types.seeded_person_type_key%TYPE;

21:
22: l_contact_type_key per_person_types.seeded_person_type_key%TYPE;
23: l_emp_type_key per_person_types.seeded_person_type_key%TYPE;
24: l_app_type_key per_person_types.seeded_person_type_key%TYPE;
25: l_cwk_type_key per_person_types.seeded_person_type_key%TYPE;
26: l_chk varchar2(1);
27: l_con varchar2(1);
28: l_app varchar2(1);
29: l_cwk varchar2(1);

Line 44: select 'Y' from per_person_types ppt, per_person_type_usages_f pptu

40: p_effective_date between papf.effective_start_date and papf.effective_end_date;
41:
42: l_csr_per_value csr_per_value%rowtype;
43: cursor csr_person_type(p_person_type_key char) is
44: select 'Y' from per_person_types ppt, per_person_type_usages_f pptu
45: where ppt.person_type_id = pptu.person_type_id and
46: pptu.person_id = p_person_id and
47: ppt.business_group_id = per_business_group_id and
48: ppt.seeded_person_type_key = p_person_type_key and