[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
2987: --
2988: hr_utility.set_location(l_proc,2);
2989: SELECT actual_termination_date
2990: INTO l_actual_termination_date
2991: FROM per_periods_of_service
2992: WHERE person_id = p_person_id
2993: AND final_process_date IS NULL
2994: AND p_final_process_date BETWEEN date_start
2995: AND to_date('31/12/4712','DD/MM/YYYY');
3437: -- end of bug 4919804
3438:
3439: cursor c1 is
3440: select *
3441: from per_periods_of_service
3442: where person_id = p_person_id
3443: and actual_termination_date = p_actual_termination_date;
3444: --
3445: -- fix 1370960
3536: , l_old_leaving_reason
3537: , l_date_start
3538: , l_final_process_date
3539: , l_last_standard_process_date
3540: FROM per_periods_of_service pos
3541: WHERE pos.person_id = p_person_id
3542: AND pos.actual_termination_date = p_actual_termination_date;
3543: --
3544: exception when NO_DATA_FOUND then
3708: --
3709: --
3710: -- END WWBUG fix for 1390173
3711: --
3712: UPDATE per_periods_of_service pos
3713: SET pos.actual_termination_date = null
3714: , pos.last_standard_process_date = null
3715: , pos.final_process_date = null
3716: , pos.termination_accepted_person_id = null
3762: --
3763: --
3764: -- END WWBUG fix for 1390173
3765: --
3766: UPDATE per_periods_of_service pos
3767: SET pos.actual_termination_date = null
3768: , pos.last_standard_process_date = null
3769: , pos.final_process_date = null
3770: , pos.termination_accepted_person_id = null