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 738: from per_people_f ppf

734: INTO l_action_chk
735: FROM sys.dual
736: WHERE exists
737: (select '1'
738: from per_people_f ppf
739: where ppf.person_id = p_person_id
740: and p_action_date < ppf.effective_start_date);
741: --
742: hr_utility.set_location(l_proc,10);

Line 762: FROM per_people_f ppf,

758: IS
759: --
760: CURSOR future_person_types IS
761: SELECT ppt.system_person_type
762: FROM per_people_f ppf,
763: per_person_types ppt
764: WHERE ppf.person_type_id = ppt.person_type_id
765: AND ppf.person_id = p_person_id
766: AND ppf.business_group_id + 0 = ppt.business_group_id + 0

Line 788: from per_people_f ppf

784: and ppt.system_person_type like 'CWK';
785:
786: cursor bus_grp_id is
787: select business_group_id
788: from per_people_f ppf
789: where person_id=p_person_id
790: and p_action_date < ppf.effective_start_date;
791: --
792: -- bug 4457651

Line 2132: FROM per_people_f pp

2128: l_ent_loop VARCHAR2(1) := 'N';
2129: --
2130: CURSOR c_employee IS
2131: SELECT *
2132: FROM per_people_f pp
2133: WHERE pp.person_id = p_person_id
2134: FOR UPDATE;
2135: --
2136: -- Added AND assignment_type = 'E' 307957 tm 19-sep-1995

Line 2206: FROM per_people_f pp

2202: --
2203: hr_utility.set_location(l_proc,10);
2204: SELECT current_employee_flag
2205: INTO l_current_employee_flag
2206: FROM per_people_f pp
2207: WHERE pp.person_id = p_person_id
2208: AND p_actual_termination_date + 1
2209: BETWEEN pp.effective_start_date
2210: AND pp.effective_end_date;

Line 2552: UPDATE per_people_f pp

2548: , c_emp_rec.global_person_id
2549: );
2550: --
2551: hr_utility.set_location(l_proc,45);
2552: UPDATE per_people_f pp
2553: SET pp.effective_end_date = p_actual_termination_date
2554: WHERE CURRENT OF c_employee;
2555: --
2556: end if;

Line 2982: FROM per_people_f pp

2978: --
2979: hr_utility.set_location(l_proc,3);
2980: SELECT current_employee_flag
2981: INTO l_current_employee_flag
2982: FROM per_people_f pp
2983: WHERE pp.person_id = p_person_id
2984: AND ((p_final_process_date = l_actual_termination_date
2985: AND p_final_process_date + 1 BETWEEN pp.effective_start_date
2986: AND pp.effective_end_date)