APPS.HREMPTER dependencies on PAY_COST_ALLOCATIONS_F

Line 443: UPDATE pay_cost_allocations_f pca

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);
443: UPDATE pay_cost_allocations_f pca
444: SET pca.effective_end_date = p_final_process_date
445: WHERE pca.assignment_id = p_assignment_id
446: AND p_final_process_date
447: BETWEEN pca.effective_start_date

Line 451: DELETE pay_cost_allocations_f pca

447: BETWEEN pca.effective_start_date
448: AND pca.effective_end_date;
449: --
450: hr_utility.set_location(l_proc,25);
451: DELETE pay_cost_allocations_f pca
452: WHERE pca.assignment_id = p_assignment_id
453: AND pca.effective_start_date > p_final_process_date;
454: --
455: hr_utility.set_location(l_proc,30);

Line 4222: UPDATE pay_cost_allocations_f pca

4218: WHERE ppm.assignment_id = c_ass_rec.assignment_id
4219: AND ppm.effective_end_date = l_final_process_date;
4220: --
4221: hr_utility.set_location(l_proc,38);
4222: UPDATE pay_cost_allocations_f pca
4223: SET pca.effective_end_date = l_effective_end_date
4224: WHERE pca.assignment_id = c_ass_rec.assignment_id
4225: AND pca.effective_end_date = l_final_process_date;
4226: --