APPS.HR_EMPLOYEE_API dependencies on PER_PERSON_TYPE_USAGES

Line 2572: from per_person_type_usages_f ptu,per_person_types ppt

2568: -- Bug 3611984 starts here
2569: l_ptu_datetrack_mode varchar2(12);
2570: cursor c_ptu_start_date is
2571: select effective_start_date
2572: from per_person_type_usages_f ptu,per_person_types ppt
2573: where ptu.person_type_id = ppt.person_type_id
2574: and ptu.person_id = p_person_id
2575: and p_hire_date between ptu.effective_start_date and ptu.effective_end_date
2576: and ppt.system_person_type='EX_EMP';

Line 2634: per_person_type_usages_f ptu

2630: per.effective_start_date,
2631: pet.system_person_type
2632: from per_person_types pet,
2633: per_people_f per,
2634: per_person_type_usages_f ptu
2635: where per.person_id = p_person_id
2636: and pet.person_type_id = ptu.person_type_id
2637: and ptu.person_id = per.person_id
2638: -- added this condition for 5601538

Line 3806: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;

3802: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3803: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3804: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3806: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
3807: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
3808: --
3809: -- Start of fix for bug 3143299
3810: l_final_process_date per_periods_of_service.final_process_date%type;

Line 3807: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;

3803: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3804: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3806: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
3807: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
3808: --
3809: -- Start of fix for bug 3143299
3810: l_final_process_date per_periods_of_service.final_process_date%type;
3811: --