APPS.HREMPTER dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 456: UPDATE per_spinal_point_placements_f spp

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);
456: UPDATE per_spinal_point_placements_f spp
457: SET spp.effective_end_date = p_final_process_date
458: WHERE spp.assignment_id = p_assignment_id
459: AND p_final_process_date
460: BETWEEN spp.effective_start_date

Line 465: DELETE per_spinal_point_placements_f spp

461: AND spp.effective_end_date;
462: --
463: -- VT 03/06/96 bug #311763
464: hr_utility.set_location(l_proc,35);
465: DELETE per_spinal_point_placements_f spp
466: WHERE spp.assignment_id = p_assignment_id
467: AND spp.effective_start_date > p_final_process_date;
468: --
469:

Line 4228: UPDATE per_spinal_point_placements_f spp

4224: WHERE pca.assignment_id = c_ass_rec.assignment_id
4225: AND pca.effective_end_date = l_final_process_date;
4226: --
4227: hr_utility.set_location(l_proc,40);
4228: UPDATE per_spinal_point_placements_f spp
4229: SET spp.effective_end_date = l_effective_end_date
4230: WHERE spp.assignment_id = c_ass_rec.assignment_id
4231: AND spp.effective_end_date = l_final_process_date;
4232: --