APPS.HREMPTER dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 418: UPDATE pay_personal_payment_methods_f ppm

414: WHERE sas.assignment_id = p_assignment_id
415: AND sas.start_date > p_final_process_date;
416: --
417: hr_utility.set_location(l_proc,10);
418: UPDATE pay_personal_payment_methods_f ppm
419: SET ppm.effective_end_date = p_final_process_date
420: WHERE ppm.assignment_id = p_assignment_id
421: AND p_final_process_date
422: BETWEEN ppm.effective_start_date

Line 426: DELETE pay_personal_payment_methods_f ppm

422: BETWEEN ppm.effective_start_date
423: AND ppm.effective_end_date;
424: --
425: hr_utility.set_location(l_proc,15);
426: DELETE pay_personal_payment_methods_f ppm
427: WHERE ppm.assignment_id = p_assignment_id
428: AND ppm.effective_start_date > p_final_process_date;
429: --
430: hr_utility.set_location(l_proc,20);

Line 4066: UPDATE pay_personal_payment_methods_f ppm

4062: WHERE sas.assignment_id = c_ass_rec.assignment_id
4063: AND sas.end_date = l_final_process_date;
4064: --
4065: hr_utility.set_location(l_proc,36);
4066: UPDATE pay_personal_payment_methods_f ppm
4067: SET ppm.effective_end_date = l_effective_end_date
4068: WHERE ppm.assignment_id = c_ass_rec.assignment_id
4069: AND ppm.effective_end_date = l_final_process_date;
4070: --