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_PEOPLE_F

Line 188: from per_people_f

184: l_address_line1 per_addresses.address_line1%type;
185: --
186: cursor csr_get_person_dob is
187: select date_of_birth
188: from per_people_f
189: where person_id = p_person_id
190: and p_effective_date between effective_start_date
191: and effective_end_date;
192: --

Line 516: -- has their D.O.B. recorded on per_people_f

512: end if;
513: hr_utility.set_location(l_proc, 70);
514: --
515: -- Check that person to whom the assignment is linked
516: -- has their D.O.B. recorded on per_people_f
517: --
518: if p_assignment_type = 'E' then
519: hr_utility.set_location(l_proc, 75);
520: if p_date_of_birth is null then

Line 1395: from per_people_f ppf

1391: l_proc varchar2(72) := g_package||'chk_person_id';
1392: --
1393: cursor csr_get_bus_grp is
1394: select ppf.business_group_id
1395: from per_people_f ppf
1396: where ppf.person_id = p_person_id
1397: and p_effective_date between ppf.effective_start_date
1398: and ppf.effective_end_date;
1399: --

Line 1459: l_current_employee_flag per_people_f.current_employee_flag%TYPE;

1455: l_proc varchar2(72) := g_package||'chk_person_referred_by_id';
1456: l_api_updating boolean;
1457: l_exists varchar2(1);
1458: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1459: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
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

Line 1460: l_current_npw_flag per_people_f.current_npw_flag%TYPE;

1456: l_api_updating boolean;
1457: l_exists varchar2(1);
1458: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1459: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
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

Line 2791: l_current_employee_flag per_people_f.current_employee_flag%TYPE;

2787: l_proc varchar2(72) := g_package||'chk_recruiter_id';
2788: l_api_updating boolean;
2789: l_vac_recruiter_id per_all_assignments_f.recruiter_id%TYPE;
2790: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2791: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
2792: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
2793: --
2794: cursor csr_val_recruiter is
2795: select business_group_id, current_employee_flag, current_npw_flag

Line 2792: l_current_npw_flag per_people_f.current_npw_flag%TYPE;

2788: l_api_updating boolean;
2789: l_vac_recruiter_id per_all_assignments_f.recruiter_id%TYPE;
2790: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2791: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
2792: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
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

Line 2796: --from per_people_f bug 5078945

2792: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
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

Line 4475: l_business_group_id per_people_f.business_group_id%TYPE;

4471: --
4472: l_proc varchar2(72) := g_package||'chk_supervisor_id';
4473: l_api_updating boolean;
4474: --
4475: l_business_group_id per_people_f.business_group_id%TYPE;
4476: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
4477: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
4478: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4479: --

Line 4476: l_current_employee_flag per_people_f.current_employee_flag%TYPE;

4472: l_proc varchar2(72) := g_package||'chk_supervisor_id';
4473: l_api_updating boolean;
4474: --
4475: l_business_group_id per_people_f.business_group_id%TYPE;
4476: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
4477: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
4478: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4479: --
4480: -- Fix for bug 4305723 starts here.

Line 4477: l_current_npw_flag per_people_f.current_npw_flag%TYPE;

4473: l_api_updating boolean;
4474: --
4475: l_business_group_id per_people_f.business_group_id%TYPE;
4476: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
4477: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
4478: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4479: --
4480: -- Fix for bug 4305723 starts here.
4481: --