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 1504: from per_all_people_f

1500: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
1501: --
1502: cursor csr_val_prb_id is
1503: select business_group_id, current_employee_flag, current_npw_flag
1504: from per_all_people_f
1505: where person_id = p_person_referred_by_id
1506: and p_validation_start_date
1507: between effective_start_date
1508: and effective_end_date;

Line 2195: FROM per_all_people_f

2191: -- 120.10 (START)
2192: --
2193: CURSOR csr_get_bg_id IS
2194: SELECT business_group_id
2195: FROM per_all_people_f
2196: WHERE person_id = p_person_id
2197: AND p_effective_date BETWEEN effective_start_date
2198: AND effective_end_date;
2199: --

Line 2200: l_bg_id per_all_people_f.business_group_id%TYPE;

2196: WHERE person_id = p_person_id
2197: AND p_effective_date BETWEEN effective_start_date
2198: AND effective_end_date;
2199: --
2200: l_bg_id per_all_people_f.business_group_id%TYPE;
2201: --
2202: CURSOR csr_chk_amends (p_bg_id per_all_people_f.business_group_id%TYPE) IS
2203: SELECT per_system_status
2204: FROM per_ass_status_type_amends

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

2198: AND effective_end_date;
2199: --
2200: l_bg_id per_all_people_f.business_group_id%TYPE;
2201: --
2202: CURSOR csr_chk_amends (p_bg_id per_all_people_f.business_group_id%TYPE) IS
2203: SELECT per_system_status
2204: FROM per_ass_status_type_amends
2205: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id
2206: AND business_group_id = csr_chk_amends.p_bg_id;

Line 2837: from per_all_people_f

2833: --
2834: cursor csr_val_recruiter is
2835: select business_group_id, current_employee_flag, current_npw_flag
2836: --from per_people_f bug 5078945
2837: from per_all_people_f
2838: where person_id = p_recruiter_id
2839: and p_validation_start_date
2840: between effective_start_date
2841: and nvl(effective_end_date, hr_api.g_eot);

Line 4525: from per_all_people_f

4521: -- Fix for bug 4305723 starts here.
4522: --
4523: cursor csr_party_id(p_per_id number) IS
4524: select party_id
4525: from per_all_people_f
4526: where person_id = p_per_id
4527: and p_validation_start_date
4528: between effective_start_date
4529: and effective_end_date;

Line 4547: from per_all_people_f

4543: and asg.effective_end_date;
4544: --
4545: cursor csr_valid_supervisor_id is
4546: select business_group_id, current_employee_flag, current_npw_flag
4547: from per_all_people_f
4548: where person_id = p_supervisor_id
4549: and p_validation_start_date
4550: between effective_start_date
4551: and effective_end_date;

Line 4557: from per_all_people_f

4553: -- Fix for Bug#8310023 starts here
4554: --
4555: cursor csr_valid_supervisor_sh_hr is
4556: select business_group_id, current_employee_flag, current_npw_flag
4557: from per_all_people_f
4558: where person_id = p_supervisor_id;
4559: --
4560: -- Fix for Bug#8310023 ends here
4561: --