APPS.HR_EMPLOYEE_API dependencies on PER_PERSON_TYPE_USAGES

Line 2883: from per_person_type_usages_f ptu,per_person_types ppt

2879: -- Bug 3611984 starts here
2880: l_ptu_datetrack_mode varchar2(12);
2881: cursor c_ptu_start_date is
2882: select effective_start_date
2883: from per_person_type_usages_f ptu,per_person_types ppt
2884: where ptu.person_type_id = ppt.person_type_id
2885: and ptu.person_id = p_person_id
2886: and p_hire_date between ptu.effective_start_date and ptu.effective_end_date
2887: and ppt.system_person_type='EX_EMP';

Line 2945: per_person_type_usages_f ptu

2941: per.effective_start_date,
2942: pet.system_person_type
2943: from per_person_types pet,
2944: per_people_f per,
2945: per_person_type_usages_f ptu
2946: where per.person_id = p_person_id
2947: and pet.person_type_id = ptu.person_type_id
2948: and ptu.person_id = per.person_id
2949: -- added this condition for 5601538

Line 4118: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;

4114: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4115: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4116: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4117: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4118: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4119: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4120: --
4121: -- Start of fix for bug 3143299
4122: l_final_process_date per_periods_of_service.final_process_date%type;

Line 4119: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;

4115: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4116: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4117: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4118: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4119: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4120: --
4121: -- Start of fix for bug 3143299
4122: l_final_process_date per_periods_of_service.final_process_date%type;
4123: --