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.

[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_PEOPLE_F

Line 4280: ,per_people_f per

4276: ,pet.system_person_type
4277: ,per.npw_number
4278: FROM per_applications apl
4279: ,per_person_types pet
4280: ,per_people_f per
4281: WHERE p_effective_date BETWEEN apl.date_received
4282: AND NVL(apl.date_end,p_effective_date)
4283: AND apl.person_id = per.person_id
4284: AND pet.person_type_id = per.person_type_id

Line 4910: FROM per_people_f per

4906: ,per.employee_number
4907: ,per.npw_number
4908: ,bus.business_group_id
4909: ,bus.legislation_code
4910: FROM per_people_f per
4911: ,per_business_groups bus
4912: ,per_person_types pet
4913: WHERE per.person_type_id = pet.person_type_id
4914: AND per.business_group_id+0 = bus.business_group_id

Line 5198: l_business_group_id per_people_f.business_group_id%type;

5194: --
5195: -- declare local variables
5196: --
5197: l_proc varchar2(72) := g_package||'apply_for_job_anytime';
5198: l_business_group_id per_people_f.business_group_id%type;
5199: l_name_combination_warning boolean;
5200: l_dob_null_warning boolean;
5201: l_orig_hire_warning boolean;
5202: l_organization_id per_business_groups.organization_id%type;

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

5200: l_dob_null_warning boolean;
5201: l_orig_hire_warning boolean;
5202: l_organization_id per_business_groups.organization_id%type;
5203: l_legislation_code per_business_groups.legislation_code%type;
5204: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
5205: l_person_type_id1 per_people_f.person_type_id%type;
5206: l_application_id per_applications.application_id%type;
5207: l_comment_id per_assignments_f.comment_id%type;
5208: l_assignment_sequence per_assignments_f.assignment_sequence%type;

Line 5205: l_person_type_id1 per_people_f.person_type_id%type;

5201: l_orig_hire_warning boolean;
5202: l_organization_id per_business_groups.organization_id%type;
5203: l_legislation_code per_business_groups.legislation_code%type;
5204: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
5205: l_person_type_id1 per_people_f.person_type_id%type;
5206: l_application_id per_applications.application_id%type;
5207: l_comment_id per_assignments_f.comment_id%type;
5208: l_assignment_sequence per_assignments_f.assignment_sequence%type;
5209: l_assignment_id per_assignments_f.assignment_id%type;

Line 5211: l_current_applicant_flag per_people_f.current_applicant_flag%type;

5207: l_comment_id per_assignments_f.comment_id%type;
5208: l_assignment_sequence per_assignments_f.assignment_sequence%type;
5209: l_assignment_id per_assignments_f.assignment_id%type;
5210: l_object_version_number per_assignments_f.object_version_number%type;
5211: l_current_applicant_flag per_people_f.current_applicant_flag%type;
5212: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
5213: l_current_employee_flag per_people_f.current_employee_flag%type;
5214: l_employee_number per_people_f.employee_number%type;
5215: l_applicant_number per_people_f.applicant_number%TYPE;

Line 5212: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

5208: l_assignment_sequence per_assignments_f.assignment_sequence%type;
5209: l_assignment_id per_assignments_f.assignment_id%type;
5210: l_object_version_number per_assignments_f.object_version_number%type;
5211: l_current_applicant_flag per_people_f.current_applicant_flag%type;
5212: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
5213: l_current_employee_flag per_people_f.current_employee_flag%type;
5214: l_employee_number per_people_f.employee_number%type;
5215: l_applicant_number per_people_f.applicant_number%TYPE;
5216: l_npw_number per_people_f.npw_number%TYPE;

Line 5213: l_current_employee_flag per_people_f.current_employee_flag%type;

5209: l_assignment_id per_assignments_f.assignment_id%type;
5210: l_object_version_number per_assignments_f.object_version_number%type;
5211: l_current_applicant_flag per_people_f.current_applicant_flag%type;
5212: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
5213: l_current_employee_flag per_people_f.current_employee_flag%type;
5214: l_employee_number per_people_f.employee_number%type;
5215: l_applicant_number per_people_f.applicant_number%TYPE;
5216: l_npw_number per_people_f.npw_number%TYPE;
5217: l_per_object_version_number per_people_f.object_version_number%TYPE;

Line 5214: l_employee_number per_people_f.employee_number%type;

5210: l_object_version_number per_assignments_f.object_version_number%type;
5211: l_current_applicant_flag per_people_f.current_applicant_flag%type;
5212: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
5213: l_current_employee_flag per_people_f.current_employee_flag%type;
5214: l_employee_number per_people_f.employee_number%type;
5215: l_applicant_number per_people_f.applicant_number%TYPE;
5216: l_npw_number per_people_f.npw_number%TYPE;
5217: l_per_object_version_number per_people_f.object_version_number%TYPE;
5218: l_full_name per_people_f.full_name%type;

Line 5215: l_applicant_number per_people_f.applicant_number%TYPE;

5211: l_current_applicant_flag per_people_f.current_applicant_flag%type;
5212: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
5213: l_current_employee_flag per_people_f.current_employee_flag%type;
5214: l_employee_number per_people_f.employee_number%type;
5215: l_applicant_number per_people_f.applicant_number%TYPE;
5216: l_npw_number per_people_f.npw_number%TYPE;
5217: l_per_object_version_number per_people_f.object_version_number%TYPE;
5218: l_full_name per_people_f.full_name%type;
5219: l_system_person_type per_person_types.system_person_type%type;

Line 5216: l_npw_number per_people_f.npw_number%TYPE;

5212: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
5213: l_current_employee_flag per_people_f.current_employee_flag%type;
5214: l_employee_number per_people_f.employee_number%type;
5215: l_applicant_number per_people_f.applicant_number%TYPE;
5216: l_npw_number per_people_f.npw_number%TYPE;
5217: l_per_object_version_number per_people_f.object_version_number%TYPE;
5218: l_full_name per_people_f.full_name%type;
5219: l_system_person_type per_person_types.system_person_type%type;
5220: l_effective_date date;

Line 5217: l_per_object_version_number per_people_f.object_version_number%TYPE;

5213: l_current_employee_flag per_people_f.current_employee_flag%type;
5214: l_employee_number per_people_f.employee_number%type;
5215: l_applicant_number per_people_f.applicant_number%TYPE;
5216: l_npw_number per_people_f.npw_number%TYPE;
5217: l_per_object_version_number per_people_f.object_version_number%TYPE;
5218: l_full_name per_people_f.full_name%type;
5219: l_system_person_type per_person_types.system_person_type%type;
5220: l_effective_date date;
5221: l_effective_start_date date;

Line 5218: l_full_name per_people_f.full_name%type;

5214: l_employee_number per_people_f.employee_number%type;
5215: l_applicant_number per_people_f.applicant_number%TYPE;
5216: l_npw_number per_people_f.npw_number%TYPE;
5217: l_per_object_version_number per_people_f.object_version_number%TYPE;
5218: l_full_name per_people_f.full_name%type;
5219: l_system_person_type per_person_types.system_person_type%type;
5220: l_effective_date date;
5221: l_effective_start_date date;
5222: l_effective_end_date date;

Line 5255: ,per_people_f ppf

5251: ,ppf.employee_number
5252: ,ppf.npw_number
5253: ,ppt.system_person_type
5254: from per_person_types ppt
5255: ,per_people_f ppf
5256: where ppf.person_id = p_person_id
5257: and ppt.person_type_id = ppf.person_type_id
5258: and ppt.business_group_id + 0 = ppf.business_group_id
5259: and (l_effective_date

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

5296: hr_utility.set_location(' Leaving:'||l_proc, 10);
5297: end if;
5298: --
5299: -- Check that this person (p_person_id) exists as of l_effective_date
5300: -- the current person type (per_people_f.person_type_id)
5301: --
5302: open csr_chk_person_exists;
5303: fetch csr_chk_person_exists into
5304: l_business_group_id