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.PER_ASG_BUS2 dependencies on PER_ALL_PEOPLE_F

Line 193: l_date_of_birth per_all_people_f.date_of_birth%type;

189: where person_id = p_person_id
190: and p_effective_date between effective_start_date
191: and effective_end_date;
192: --
193: l_date_of_birth per_all_people_f.date_of_birth%type;
194: l_payroll_id_updated boolean;
195: --
196: begin
197: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 248: ,p_date_of_birth in per_all_people_f.date_of_birth%type

244: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
245: ,p_effective_date in date
246: ,p_datetrack_mode in varchar2
247: ,p_address_line1 in per_addresses.address_line1%type
248: ,p_date_of_birth in per_all_people_f.date_of_birth%type
249: ,p_payroll_id_updated out nocopy boolean
250: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
251: )
252: is

Line 1464: from per_all_people_f

1460: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
1461: --
1462: cursor csr_val_prb_id is
1463: select business_group_id, current_employee_flag, current_npw_flag
1464: from per_all_people_f
1465: where person_id = p_person_referred_by_id
1466: and p_validation_start_date
1467: between effective_start_date
1468: and effective_end_date;

Line 2155: FROM per_all_people_f

2151: -- 120.10 (START)
2152: --
2153: CURSOR csr_get_bg_id IS
2154: SELECT business_group_id
2155: FROM per_all_people_f
2156: WHERE person_id = p_person_id
2157: AND p_effective_date BETWEEN effective_start_date
2158: AND effective_end_date;
2159: --

Line 2160: l_bg_id per_all_people_f.business_group_id%TYPE;

2156: WHERE person_id = p_person_id
2157: AND p_effective_date BETWEEN effective_start_date
2158: AND effective_end_date;
2159: --
2160: l_bg_id per_all_people_f.business_group_id%TYPE;
2161: --
2162: CURSOR csr_chk_amends (p_bg_id per_all_people_f.business_group_id%TYPE) IS
2163: SELECT per_system_status
2164: FROM per_ass_status_type_amends

Line 2162: CURSOR csr_chk_amends (p_bg_id per_all_people_f.business_group_id%TYPE) IS

2158: AND effective_end_date;
2159: --
2160: l_bg_id per_all_people_f.business_group_id%TYPE;
2161: --
2162: CURSOR csr_chk_amends (p_bg_id per_all_people_f.business_group_id%TYPE) IS
2163: SELECT per_system_status
2164: FROM per_ass_status_type_amends
2165: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id
2166: AND business_group_id = csr_chk_amends.p_bg_id;

Line 2797: from per_all_people_f

2793: --
2794: cursor csr_val_recruiter is
2795: select business_group_id, current_employee_flag, current_npw_flag
2796: --from per_people_f bug 5078945
2797: from per_all_people_f
2798: where person_id = p_recruiter_id
2799: and p_validation_start_date
2800: between effective_start_date
2801: and nvl(effective_end_date, hr_api.g_eot);

Line 4484: from per_all_people_f

4480: -- Fix for bug 4305723 starts here.
4481: --
4482: cursor csr_party_id(p_per_id number) IS
4483: select party_id
4484: from per_all_people_f
4485: where person_id = p_per_id
4486: and p_validation_start_date
4487: between effective_start_date
4488: and effective_end_date;

Line 4506: from per_all_people_f

4502: and asg.effective_end_date;
4503: --
4504: cursor csr_valid_supervisor_id is
4505: select business_group_id, current_employee_flag, current_npw_flag
4506: from per_all_people_f
4507: where person_id = p_supervisor_id
4508: and p_validation_start_date
4509: between effective_start_date
4510: and effective_end_date;