APPS.HR_CONTACT_API dependencies on PER_PERSON_TYPES

Line 131: l_person_type_id per_person_types.person_type_id%type:=

127: where business_group_id = p_business_group_id;
128: l_legislation_code per_business_groups.legislation_code%type;
129: -- 3406332 ends here.
130: l_proc varchar2(72) := g_package||'create_person';
131: l_person_type_id per_person_types.person_type_id%type:=
132: p_person_type_id;
133: l_person_id per_people_f.person_id%type;
134: l_start_date per_all_people_f.start_date%TYPE;
135: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;

Line 444: from per_person_types

440: --
441: if p_person_type_id is not null and p_person_type_id <> hr_api.g_number then
442: begin
443: select person_type_id into l_person_type_id
444: from per_person_types
445: where person_type_id = p_person_type_id
446: and business_group_id = p_business_group_id
447: and active_flag = 'Y'
448: and system_person_type = 'OTHER';