APPS.HR_PERIODS_OF_SERVICE_API dependencies on PER_SECONDARY_ASS_STATUSES

Line 884: FROM per_secondary_ass_statuses sas

880: FOR UPDATE NOWAIT;
881: --
882: CURSOR csr_lock_sas (p_assignment_id NUMBER) IS
883: SELECT NULL
884: FROM per_secondary_ass_statuses sas
885: WHERE sas.assignment_id = csr_lock_sas.p_assignment_id
886: FOR UPDATE NOWAIT;
887: --
888: CURSOR csr_lock_pyp (p_assignment_id NUMBER) IS

Line 1141: UPDATE per_secondary_ass_statuses

1137: WHERE assignment_id = l_assignment_id
1138: AND p_old_final_process_date BETWEEN effective_start_date
1139: AND effective_end_date;
1140: --
1141: UPDATE per_secondary_ass_statuses
1142: SET end_date = l_new_final_process_date
1143: WHERE assignment_id = l_assignment_id
1144: AND NVL(end_date,p_old_final_process_date) = p_old_final_process_date;
1145: --