APPS.HR_APPLICANT_API dependencies on PER_PERSON_TYPE_USAGES

Line 4334: FROM per_person_type_usages_f ptu

4330: for update nowait;
4331: --
4332: CURSOR csr_lock_ptu(cp_person_id number, cp_termination_date date) IS
4333: SELECT null
4334: FROM per_person_type_usages_f ptu
4335: ,per_person_types ppt
4336: WHERE person_id = cp_person_id
4337: AND (effective_start_date > cp_termination_date
4338: OR

Line 4883: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;

4879: l_apl_object_version_number per_applications.object_version_number%TYPE;
4880: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4881: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4882: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4883: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4884: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4885: --
4886: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;
4887: lv_applicant_number per_all_people_f.applicant_number%TYPE := p_applicant_number ;

Line 4884: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;

4880: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4881: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4882: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4883: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4884: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4885: --
4886: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;
4887: lv_applicant_number per_all_people_f.applicant_number%TYPE := p_applicant_number ;
4888: l_datetrack_mode varchar2(30); -- Bug 2738584