eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_APPLICANT_API dependencies on PER_PEOPLE_F

Line 3211: ,per_people_f per

3207: ,pet.system_person_type
3208: ,per.npw_number
3209: FROM per_applications apl
3210: ,per_person_types pet
3211: ,per_people_f per
3212: WHERE p_effective_date BETWEEN apl.date_received
3213: AND NVL(apl.date_end,p_effective_date)
3214: AND apl.person_id = per.person_id
3215: AND pet.person_type_id = per.person_type_id

Line 3837: FROM per_people_f per

3833: ,per.employee_number
3834: ,per.npw_number
3835: ,bus.business_group_id
3836: ,bus.legislation_code
3837: FROM per_people_f per
3838: ,per_business_groups bus
3839: ,per_person_types pet
3840: WHERE per.person_type_id = pet.person_type_id
3841: AND per.business_group_id+0 = bus.business_group_id

Line 4125: l_business_group_id per_people_f.business_group_id%type;

4121: --
4122: -- declare local variables
4123: --
4124: l_proc varchar2(72) := g_package||'apply_for_job_anytime';
4125: l_business_group_id per_people_f.business_group_id%type;
4126: l_name_combination_warning boolean;
4127: l_dob_null_warning boolean;
4128: l_orig_hire_warning boolean;
4129: l_organization_id per_business_groups.organization_id%type;

Line 4131: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;

4127: l_dob_null_warning boolean;
4128: l_orig_hire_warning boolean;
4129: l_organization_id per_business_groups.organization_id%type;
4130: l_legislation_code per_business_groups.legislation_code%type;
4131: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
4132: l_person_type_id1 per_people_f.person_type_id%type;
4133: l_application_id per_applications.application_id%type;
4134: l_comment_id per_assignments_f.comment_id%type;
4135: l_assignment_sequence per_assignments_f.assignment_sequence%type;

Line 4132: l_person_type_id1 per_people_f.person_type_id%type;

4128: l_orig_hire_warning boolean;
4129: l_organization_id per_business_groups.organization_id%type;
4130: l_legislation_code per_business_groups.legislation_code%type;
4131: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
4132: l_person_type_id1 per_people_f.person_type_id%type;
4133: l_application_id per_applications.application_id%type;
4134: l_comment_id per_assignments_f.comment_id%type;
4135: l_assignment_sequence per_assignments_f.assignment_sequence%type;
4136: l_assignment_id per_assignments_f.assignment_id%type;

Line 4138: l_current_applicant_flag per_people_f.current_applicant_flag%type;

4134: l_comment_id per_assignments_f.comment_id%type;
4135: l_assignment_sequence per_assignments_f.assignment_sequence%type;
4136: l_assignment_id per_assignments_f.assignment_id%type;
4137: l_object_version_number per_assignments_f.object_version_number%type;
4138: l_current_applicant_flag per_people_f.current_applicant_flag%type;
4139: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
4140: l_current_employee_flag per_people_f.current_employee_flag%type;
4141: l_employee_number per_people_f.employee_number%type;
4142: l_applicant_number per_people_f.applicant_number%TYPE;

Line 4139: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

4135: l_assignment_sequence per_assignments_f.assignment_sequence%type;
4136: l_assignment_id per_assignments_f.assignment_id%type;
4137: l_object_version_number per_assignments_f.object_version_number%type;
4138: l_current_applicant_flag per_people_f.current_applicant_flag%type;
4139: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
4140: l_current_employee_flag per_people_f.current_employee_flag%type;
4141: l_employee_number per_people_f.employee_number%type;
4142: l_applicant_number per_people_f.applicant_number%TYPE;
4143: l_npw_number per_people_f.npw_number%TYPE;

Line 4140: l_current_employee_flag per_people_f.current_employee_flag%type;

4136: l_assignment_id per_assignments_f.assignment_id%type;
4137: l_object_version_number per_assignments_f.object_version_number%type;
4138: l_current_applicant_flag per_people_f.current_applicant_flag%type;
4139: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
4140: l_current_employee_flag per_people_f.current_employee_flag%type;
4141: l_employee_number per_people_f.employee_number%type;
4142: l_applicant_number per_people_f.applicant_number%TYPE;
4143: l_npw_number per_people_f.npw_number%TYPE;
4144: l_per_object_version_number per_people_f.object_version_number%TYPE;

Line 4141: l_employee_number per_people_f.employee_number%type;

4137: l_object_version_number per_assignments_f.object_version_number%type;
4138: l_current_applicant_flag per_people_f.current_applicant_flag%type;
4139: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
4140: l_current_employee_flag per_people_f.current_employee_flag%type;
4141: l_employee_number per_people_f.employee_number%type;
4142: l_applicant_number per_people_f.applicant_number%TYPE;
4143: l_npw_number per_people_f.npw_number%TYPE;
4144: l_per_object_version_number per_people_f.object_version_number%TYPE;
4145: l_full_name per_people_f.full_name%type;

Line 4142: l_applicant_number per_people_f.applicant_number%TYPE;

4138: l_current_applicant_flag per_people_f.current_applicant_flag%type;
4139: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
4140: l_current_employee_flag per_people_f.current_employee_flag%type;
4141: l_employee_number per_people_f.employee_number%type;
4142: l_applicant_number per_people_f.applicant_number%TYPE;
4143: l_npw_number per_people_f.npw_number%TYPE;
4144: l_per_object_version_number per_people_f.object_version_number%TYPE;
4145: l_full_name per_people_f.full_name%type;
4146: l_system_person_type per_person_types.system_person_type%type;

Line 4143: l_npw_number per_people_f.npw_number%TYPE;

4139: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
4140: l_current_employee_flag per_people_f.current_employee_flag%type;
4141: l_employee_number per_people_f.employee_number%type;
4142: l_applicant_number per_people_f.applicant_number%TYPE;
4143: l_npw_number per_people_f.npw_number%TYPE;
4144: l_per_object_version_number per_people_f.object_version_number%TYPE;
4145: l_full_name per_people_f.full_name%type;
4146: l_system_person_type per_person_types.system_person_type%type;
4147: l_effective_date date;

Line 4144: l_per_object_version_number per_people_f.object_version_number%TYPE;

4140: l_current_employee_flag per_people_f.current_employee_flag%type;
4141: l_employee_number per_people_f.employee_number%type;
4142: l_applicant_number per_people_f.applicant_number%TYPE;
4143: l_npw_number per_people_f.npw_number%TYPE;
4144: l_per_object_version_number per_people_f.object_version_number%TYPE;
4145: l_full_name per_people_f.full_name%type;
4146: l_system_person_type per_person_types.system_person_type%type;
4147: l_effective_date date;
4148: l_effective_start_date date;

Line 4145: l_full_name per_people_f.full_name%type;

4141: l_employee_number per_people_f.employee_number%type;
4142: l_applicant_number per_people_f.applicant_number%TYPE;
4143: l_npw_number per_people_f.npw_number%TYPE;
4144: l_per_object_version_number per_people_f.object_version_number%TYPE;
4145: l_full_name per_people_f.full_name%type;
4146: l_system_person_type per_person_types.system_person_type%type;
4147: l_effective_date date;
4148: l_effective_start_date date;
4149: l_effective_end_date date;

Line 4182: ,per_people_f ppf

4178: ,ppf.employee_number
4179: ,ppf.npw_number
4180: ,ppt.system_person_type
4181: from per_person_types ppt
4182: ,per_people_f ppf
4183: where ppf.person_id = p_person_id
4184: and ppt.person_type_id = ppf.person_type_id
4185: and ppt.business_group_id + 0 = ppf.business_group_id
4186: and (l_effective_date

Line 4227: -- the current person type (per_people_f.person_type_id)

4223: hr_utility.set_location(' Leaving:'||l_proc, 10);
4224: end if;
4225: --
4226: -- Check that this person (p_person_id) exists as of l_effective_date
4227: -- the current person type (per_people_f.person_type_id)
4228: --
4229: open csr_chk_person_exists;
4230: fetch csr_chk_person_exists into
4231: l_business_group_id