[Home] [Help]
210: 115.15 04-Aug-2000 Dscully 1348553 Fixed end dating of tax records.
211: 115.16 12-Sep-2000 MReid 889806 Excluded Magnetic Reports from check for
212: future dated completed actions.
213: 115.17 15-SEP-00 GPERRY Added hook points to benefits code whenerever
214: per_periods_of_service is inserted or updated.
215: Fixed WWBUG 1390173
216: 115.18 15-SEP-00 GPERRY Leapfrog of 115.16 with fix for
217: WWBUG 1390173.
218: 115.19 06-OCT-00 TMATHERS 11.5.3 incompatibility, 1348553 is patchset B for
2969: --
2970: hr_utility.set_location(l_proc,2);
2971: SELECT actual_termination_date
2972: INTO l_actual_termination_date
2973: FROM per_periods_of_service
2974: WHERE person_id = p_person_id
2975: AND final_process_date IS NULL
2976: AND p_final_process_date BETWEEN date_start
2977: AND to_date('31/12/4712','DD/MM/YYYY');
3393: -- end of bug 4919804
3394:
3395: cursor c1 is
3396: select *
3397: from per_periods_of_service
3398: where person_id = p_person_id
3399: and actual_termination_date = p_actual_termination_date;
3400: --
3401: -- fix 1370960
3469: , l_old_leaving_reason
3470: , l_date_start
3471: , l_final_process_date
3472: , l_last_standard_process_date
3473: FROM per_periods_of_service pos
3474: WHERE pos.person_id = p_person_id
3475: AND pos.actual_termination_date = p_actual_termination_date;
3476: --
3477: exception when NO_DATA_FOUND then
3590: --
3591: --
3592: -- END WWBUG fix for 1390173
3593: --
3594: UPDATE per_periods_of_service pos
3595: SET pos.actual_termination_date = null
3596: , pos.last_standard_process_date = null
3597: , pos.final_process_date = null
3598: , pos.termination_accepted_person_id = null
3644: --
3645: --
3646: -- END WWBUG fix for 1390173
3647: --
3648: UPDATE per_periods_of_service pos
3649: SET pos.actual_termination_date = null
3650: , pos.last_standard_process_date = null
3651: , pos.final_process_date = null
3652: , pos.termination_accepted_person_id = null