APPS.HREMPTER dependencies on PER_PEOPLE_F

Line 180: 115.1 16-OCT-1998 CCarter New parameters added to insert into per_people_f

176: 1. delete_assign_fpd - include deletion/update of
177: assignment_budget_values_f
178: 2. cancel_termination - inclusing of update to assignment_budget
179: values_f when the termination is cancelled.
180: 115.1 16-OCT-1998 CCarter New parameters added to insert into per_people_f
181: in the terminate employee procedure for OAB.
182: 115.5 19-Jul-1999 mmillmor 895018 removed some bad code and altered to use
183: internal security procedures in terminate
184: 115.6 27-Sep-1999 alogue Changed insert into per_People to per_all_people_f

Line 750: from per_people_f ppf

746: INTO l_action_chk
747: FROM sys.dual
748: WHERE exists
749: (select '1'
750: from per_people_f ppf
751: where ppf.person_id = p_person_id
752: and p_action_date < ppf.effective_start_date);
753: --
754: hr_utility.set_location(l_proc,10);

Line 774: FROM per_people_f ppf,

770: IS
771: --
772: CURSOR future_person_types IS
773: SELECT ppt.system_person_type
774: FROM per_people_f ppf,
775: per_person_types ppt
776: WHERE ppf.person_type_id = ppt.person_type_id
777: AND ppf.person_id = p_person_id
778: AND ppf.business_group_id + 0 = ppt.business_group_id + 0

Line 800: from per_people_f ppf

796: and ppt.system_person_type like 'CWK';
797:
798: cursor bus_grp_id is
799: select business_group_id
800: from per_people_f ppf
801: where person_id=p_person_id
802: and p_action_date < ppf.effective_start_date;
803: --
804: -- bug 4457651

Line 2150: FROM per_people_f pp

2146: l_ent_loop VARCHAR2(1) := 'N';
2147: --
2148: CURSOR c_employee IS
2149: SELECT *
2150: FROM per_people_f pp
2151: WHERE pp.person_id = p_person_id
2152: FOR UPDATE;
2153: --
2154: -- Added AND assignment_type = 'E' 307957 tm 19-sep-1995

Line 2224: FROM per_people_f pp

2220: --
2221: hr_utility.set_location(l_proc,10);
2222: SELECT current_employee_flag
2223: INTO l_current_employee_flag
2224: FROM per_people_f pp
2225: WHERE pp.person_id = p_person_id
2226: AND p_actual_termination_date + 1
2227: BETWEEN pp.effective_start_date
2228: AND pp.effective_end_date;

Line 2570: UPDATE per_people_f pp

2566: , c_emp_rec.global_person_id
2567: );
2568: --
2569: hr_utility.set_location(l_proc,45);
2570: UPDATE per_people_f pp
2571: SET pp.effective_end_date = p_actual_termination_date
2572: WHERE CURRENT OF c_employee;
2573: --
2574: end if;

Line 3000: FROM per_people_f pp

2996: --
2997: hr_utility.set_location(l_proc,3);
2998: SELECT current_employee_flag
2999: INTO l_current_employee_flag
3000: FROM per_people_f pp
3001: WHERE pp.person_id = p_person_id
3002: AND ((p_final_process_date = l_actual_termination_date
3003: AND p_final_process_date + 1 BETWEEN pp.effective_start_date
3004: AND pp.effective_end_date)