eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERIODS_OF_SERVICE_API dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 882: FROM per_spinal_point_placements_f spp

878: FOR UPDATE NOWAIT;
879: --
880: CURSOR csr_lock_spp (p_assignment_id NUMBER) IS
881: SELECT NULL
882: FROM per_spinal_point_placements_f spp
883: WHERE spp.assignment_id = csr_lock_spp.p_assignment_id
884: FOR UPDATE NOWAIT;
885: --
886: CURSOR csr_lock_ppm (p_assignment_id NUMBER) IS

Line 1389: UPDATE per_spinal_point_placements_f

1385: WHERE assignment_id = l_assignment_id
1386: AND p_old_final_process_date BETWEEN effective_start_date
1387: AND effective_end_date;
1388: --
1389: UPDATE per_spinal_point_placements_f
1390: SET effective_end_date = l_new_final_process_date
1391: WHERE assignment_id = l_assignment_id
1392: AND p_old_final_process_date BETWEEN effective_start_date
1393: AND effective_end_date;