APPS.HR_PERIODS_OF_SERVICE_API dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 872: FROM per_spinal_point_placements_f spp

868: FOR UPDATE NOWAIT;
869: --
870: CURSOR csr_lock_spp (p_assignment_id NUMBER) IS
871: SELECT NULL
872: FROM per_spinal_point_placements_f spp
873: WHERE spp.assignment_id = csr_lock_spp.p_assignment_id
874: FOR UPDATE NOWAIT;
875: --
876: CURSOR csr_lock_ppm (p_assignment_id NUMBER) IS

Line 1080: UPDATE per_spinal_point_placements_f

1076: WHERE assignment_id = l_assignment_id
1077: AND p_old_final_process_date BETWEEN effective_start_date
1078: AND effective_end_date;
1079: --
1080: UPDATE per_spinal_point_placements_f
1081: SET effective_end_date = l_new_final_process_date
1082: WHERE assignment_id = l_assignment_id
1083: AND p_old_final_process_date BETWEEN effective_start_date
1084: AND effective_end_date;