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 551: -- has their D.O.B. recorded on per_people_f

547: end if;
548: hr_utility.set_location(l_proc, 70);
549: --
550: -- Check that person to whom the assignment is linked
551: -- has their D.O.B. recorded on per_people_f
552: --
553: if p_assignment_type = 'E' then
554: hr_utility.set_location(l_proc, 75);
555: if p_date_of_birth is null then

Line 1435: from per_people_f ppf

1431: l_proc varchar2(72) := g_package||'chk_person_id';
1432: --
1433: cursor csr_get_bus_grp is
1434: select ppf.business_group_id
1435: from per_people_f ppf
1436: where ppf.person_id = p_person_id
1437: and p_effective_date between ppf.effective_start_date
1438: and ppf.effective_end_date;
1439: --

Line 1499: l_current_employee_flag per_people_f.current_employee_flag%TYPE;

1495: l_proc varchar2(72) := g_package||'chk_person_referred_by_id';
1496: l_api_updating boolean;
1497: l_exists varchar2(1);
1498: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1499: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
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

Line 1500: l_current_npw_flag per_people_f.current_npw_flag%TYPE;

1496: l_api_updating boolean;
1497: l_exists varchar2(1);
1498: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1499: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
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

Line 2831: l_current_employee_flag per_people_f.current_employee_flag%TYPE;

2827: l_proc varchar2(72) := g_package||'chk_recruiter_id';
2828: l_api_updating boolean;
2829: l_vac_recruiter_id per_all_assignments_f.recruiter_id%TYPE;
2830: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2831: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
2832: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
2833: --
2834: cursor csr_val_recruiter is
2835: select business_group_id, current_employee_flag, current_npw_flag

Line 2832: l_current_npw_flag per_people_f.current_npw_flag%TYPE;

2828: l_api_updating boolean;
2829: l_vac_recruiter_id per_all_assignments_f.recruiter_id%TYPE;
2830: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2831: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
2832: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
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

Line 2836: --from per_people_f bug 5078945

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

Line 4516: l_business_group_id per_people_f.business_group_id%TYPE;

4512: l_proc varchar2(72) := g_package||'chk_supervisor_id';
4513: l_api_updating boolean;
4514: l_inst_type varchar2(1); -- Added for bug 8310023
4515: --
4516: l_business_group_id per_people_f.business_group_id%TYPE;
4517: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
4518: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
4519: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4520: --

Line 4517: l_current_employee_flag per_people_f.current_employee_flag%TYPE;

4513: l_api_updating boolean;
4514: l_inst_type varchar2(1); -- Added for bug 8310023
4515: --
4516: l_business_group_id per_people_f.business_group_id%TYPE;
4517: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
4518: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
4519: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4520: --
4521: -- Fix for bug 4305723 starts here.

Line 4518: l_current_npw_flag per_people_f.current_npw_flag%TYPE;

4514: l_inst_type varchar2(1); -- Added for bug 8310023
4515: --
4516: l_business_group_id per_people_f.business_group_id%TYPE;
4517: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
4518: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
4519: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4520: --
4521: -- Fix for bug 4305723 starts here.
4522: --