APPS.HR_PERIODS_OF_SERVICE_API dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 902: FROM per_assignment_budget_values_f

898: FOR UPDATE NOWAIT;
899: --
900: CURSOR csr_lock_abv (p_assignment_id NUMBER) IS
901: SELECT assignment_budget_value_id
902: FROM per_assignment_budget_values_f
903: WHERE assignment_id = csr_lock_abv.p_assignment_id
904: AND p_new_final_process_date BETWEEN effective_start_date
905: AND effective_end_date
906: FOR UPDATE NOWAIT;

Line 1086: UPDATE per_assignment_budget_values_f

1082: WHERE assignment_id = l_assignment_id
1083: AND p_old_final_process_date BETWEEN effective_start_date
1084: AND effective_end_date;
1085: --
1086: UPDATE per_assignment_budget_values_f
1087: SET effective_end_date = l_new_final_process_date
1088: WHERE assignment_id = l_assignment_id
1089: AND p_old_final_process_date BETWEEN effective_start_date
1090: AND effective_end_date;