APPS.HREMPTER dependencies on PAY_COST_ALLOCATIONS_F

Line 431: UPDATE pay_cost_allocations_f pca

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);
431: UPDATE pay_cost_allocations_f pca
432: SET pca.effective_end_date = p_final_process_date
433: WHERE pca.assignment_id = p_assignment_id
434: AND p_final_process_date
435: BETWEEN pca.effective_start_date

Line 439: DELETE pay_cost_allocations_f pca

435: BETWEEN pca.effective_start_date
436: AND pca.effective_end_date;
437: --
438: hr_utility.set_location(l_proc,25);
439: DELETE pay_cost_allocations_f pca
440: WHERE pca.assignment_id = p_assignment_id
441: AND pca.effective_start_date > p_final_process_date;
442: --
443: hr_utility.set_location(l_proc,30);

Line 4072: UPDATE pay_cost_allocations_f pca

4068: WHERE ppm.assignment_id = c_ass_rec.assignment_id
4069: AND ppm.effective_end_date = l_final_process_date;
4070: --
4071: hr_utility.set_location(l_proc,38);
4072: UPDATE pay_cost_allocations_f pca
4073: SET pca.effective_end_date = l_effective_end_date
4074: WHERE pca.assignment_id = c_ass_rec.assignment_id
4075: AND pca.effective_end_date = l_final_process_date;
4076: --