APPS.HREMPTER dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 430: UPDATE pay_personal_payment_methods_f ppm

426: WHERE sas.assignment_id = p_assignment_id
427: AND sas.start_date > p_final_process_date;
428: --
429: hr_utility.set_location(l_proc,10);
430: UPDATE pay_personal_payment_methods_f ppm
431: SET ppm.effective_end_date = p_final_process_date
432: WHERE ppm.assignment_id = p_assignment_id
433: AND p_final_process_date
434: BETWEEN ppm.effective_start_date

Line 438: DELETE pay_personal_payment_methods_f ppm

434: BETWEEN ppm.effective_start_date
435: AND ppm.effective_end_date;
436: --
437: hr_utility.set_location(l_proc,15);
438: DELETE pay_personal_payment_methods_f ppm
439: WHERE ppm.assignment_id = p_assignment_id
440: AND ppm.effective_start_date > p_final_process_date;
441: --
442: hr_utility.set_location(l_proc,20);

Line 4216: UPDATE pay_personal_payment_methods_f ppm

4212: WHERE sas.assignment_id = c_ass_rec.assignment_id
4213: AND sas.end_date = l_final_process_date;
4214: --
4215: hr_utility.set_location(l_proc,36);
4216: UPDATE pay_personal_payment_methods_f ppm
4217: SET ppm.effective_end_date = l_effective_end_date
4218: WHERE ppm.assignment_id = c_ass_rec.assignment_id
4219: AND ppm.effective_end_date = l_final_process_date;
4220: --