APPS.HREMPTER dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 444: UPDATE per_spinal_point_placements_f spp

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

Line 453: DELETE per_spinal_point_placements_f spp

449: AND spp.effective_end_date;
450: --
451: -- VT 03/06/96 bug #311763
452: hr_utility.set_location(l_proc,35);
453: DELETE per_spinal_point_placements_f spp
454: WHERE spp.assignment_id = p_assignment_id
455: AND spp.effective_start_date > p_final_process_date;
456: --
457:

Line 4078: UPDATE per_spinal_point_placements_f spp

4074: WHERE pca.assignment_id = c_ass_rec.assignment_id
4075: AND pca.effective_end_date = l_final_process_date;
4076: --
4077: hr_utility.set_location(l_proc,40);
4078: UPDATE per_spinal_point_placements_f spp
4079: SET spp.effective_end_date = l_effective_end_date
4080: WHERE spp.assignment_id = c_ass_rec.assignment_id
4081: AND spp.effective_end_date = l_final_process_date;
4082: --