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.HREMPTER dependencies on PER_ALL_PEOPLE_F

Line 184: 115.6 27-Sep-1999 alogue Changed insert into per_People to per_all_people_f

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
185: inside terminate_employee.
186: 115.8 27-OCT-1999 rmonge Added code fixes for bug 920233 and 969491
187: Bug fix 920233 resolves the problem
188: with tax records not reversed when reverse

Line 205: into per_all_people_f insert in terminate_employee.

201: employee. Requested by John Rhodes
202: following French Phase 1.
203: 115.12 13-MAR-2000 CSimpson Added town_of_birth, region_of_birth,
204: country_of_birth and global_person_id attribs
205: into per_all_people_f insert in terminate_employee.
206: 115.13 26-Jul-2000 mmillmor 996015 Added code to delete pay proposals at the same
207: time as element entries
208: 115.14 17-Aug-2000 VTreiger 1363723 Commented out nocopy copying of ATTRIBUTEx columns
209: from EMP record to EX_EMP record.

Line 250: 115.33 05-NOV-01 kmullapu Modified INSERT INTO PER_ALL_PEOPLE_F in

246: 115.31 30-Oct-01 mbocutt 1271513 Change cancel terminate code to correctly
247: handle future dated assignments on reverse
248: termination.
249: 115.32 01-Nov-01 mbocutt Added som emissed variable declarations.
250: 115.33 05-NOV-01 kmullapu Modified INSERT INTO PER_ALL_PEOPLE_F in
251: terminate_employee to include
252: PER_INFORMATION 21 TO 30
253: 115.35 22-AUG-02 adhunter correct gscc warning. change msg name
254: HR_6519_CANC_ACTIONS_EXIST

Line 772: l_bus_id per_all_people_f.business_group_id %type;

768: --
769: --bug 4457651
770: --
771: L_TYPE VARCHAR2(100);
772: l_bus_id per_all_people_f.business_group_id %type;
773:
774: CURSOR fptypes_for_cwk1 IS
775: SELECT ppt.system_person_type
776: FROM

Line 2274: INSERT INTO PER_ALL_PEOPLE_F

2270: OR (c_emp_rec.current_applicant_flag IS NULL
2271: AND system_person_type = 'EX_EMP'));
2272: --
2273: hr_utility.set_location(l_proc,40);
2274: INSERT INTO PER_ALL_PEOPLE_F
2275: (person_id
2276: ,effective_start_date
2277: ,effective_end_date
2278: ,business_group_id

Line 3533: UPDATE per_all_people_f pp

3529: hr_utility.set_location(l_proc,3);
3530: FPD_FLAG := (l_final_process_date IS NOT NULL);
3531: --
3532: hr_utility.set_location(l_proc,4);
3533: UPDATE per_all_people_f pp
3534: SET pp.effective_end_date = to_date('31/12/4712','DD/MM/YYYY')
3535: WHERE pp.person_id = p_person_id
3536: AND p_actual_termination_date
3537: BETWEEN pp.effective_start_date

Line 3541: DELETE per_all_people_f pp

3537: BETWEEN pp.effective_start_date
3538: AND pp.effective_end_date;
3539: --
3540: hr_utility.set_location(l_proc,6);
3541: DELETE per_all_people_f pp
3542: WHERE pp.person_id = p_person_id
3543: AND pp.effective_start_date > p_actual_termination_date;
3544: --
3545: hr_utility.set_location(l_proc,8);