APPS.HR_APPLICANT_API dependencies on PER_PERSON_TYPE_USAGES

Line 3265: FROM per_person_type_usages_f ptu

3261: for update nowait;
3262: --
3263: CURSOR csr_lock_ptu(cp_person_id number, cp_termination_date date) IS
3264: SELECT null
3265: FROM per_person_type_usages_f ptu
3266: ,per_person_types ppt
3267: WHERE person_id = cp_person_id
3268: AND (effective_start_date > cp_termination_date
3269: OR

Line 3810: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;

3806: l_apl_object_version_number per_applications.object_version_number%TYPE;
3807: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3808: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3810: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
3811: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
3812: --
3813: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;
3814: lv_applicant_number per_all_people_f.applicant_number%TYPE := p_applicant_number ;

Line 3811: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;

3807: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3808: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3810: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
3811: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
3812: --
3813: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;
3814: lv_applicant_number per_all_people_f.applicant_number%TYPE := p_applicant_number ;
3815: l_datetrack_mode varchar2(30); -- Bug 2738584