APPS.PER_QH_ACTION dependencies on PER_PERSON_TYPES

Line 30: l_system_person_type per_person_types.system_person_type%TYPE;

26: -- Declare cursors and local variables
27: --
28: l_proc varchar2(72) := g_package||'quick_hire_applicant';
29: l_dummy number;
30: l_system_person_type per_person_types.system_person_type%TYPE;
31: l_system_person_type2 per_person_types.system_person_type%TYPE;
32: l_business_group_id per_all_people_f.business_group_id%TYPE;
33: l_legislation_code per_business_groups.legislation_code%TYPE;
34: l_application_id per_applications.application_id%TYPE;

Line 31: l_system_person_type2 per_person_types.system_person_type%TYPE;

27: --
28: l_proc varchar2(72) := g_package||'quick_hire_applicant';
29: l_dummy number;
30: l_system_person_type per_person_types.system_person_type%TYPE;
31: l_system_person_type2 per_person_types.system_person_type%TYPE;
32: l_business_group_id per_all_people_f.business_group_id%TYPE;
33: l_legislation_code per_business_groups.legislation_code%TYPE;
34: l_application_id per_applications.application_id%TYPE;
35: l_apl_object_version_number per_applications.application_id%TYPE;

Line 70: per_person_types ppt

66: select ppt.system_person_type,
67: per.effective_start_date,
68: per.object_version_number
69: from per_all_people_f per,
70: per_person_types ppt
71: where per.person_type_id = ppt.person_type_id
72: and per.person_id = p_person_id
73: and p_date between per.effective_start_date
74: and per.effective_end_date;