APPS.HR_PERIODS_OF_SERVICE_API dependencies on PER_SECONDARY_ASS_STATUSES

Line 894: FROM per_secondary_ass_statuses sas

890: FOR UPDATE NOWAIT;
891: --
892: CURSOR csr_lock_sas (p_assignment_id NUMBER) IS
893: SELECT NULL
894: FROM per_secondary_ass_statuses sas
895: WHERE sas.assignment_id = csr_lock_sas.p_assignment_id
896: FOR UPDATE NOWAIT;
897: --
898: CURSOR csr_lock_pyp (p_assignment_id NUMBER) IS

Line 1451: UPDATE per_secondary_ass_statuses

1447: WHERE assignment_id = l_assignment_id
1448: AND p_old_final_process_date BETWEEN effective_start_date
1449: AND effective_end_date;
1450: --
1451: UPDATE per_secondary_ass_statuses
1452: SET end_date = l_new_final_process_date
1453: WHERE assignment_id = l_assignment_id
1454: AND NVL(end_date,p_old_final_process_date) = p_old_final_process_date;
1455: --