APPS.HR_CONTINGENT_WORKER_API dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 3726: from per_assignment_budget_values_f

3722: -- Start of Fix for WWBUG 1408379
3723: --
3724: cursor c2(p_assignment_id number) is
3725: select *
3726: from per_assignment_budget_values_f
3727: where assignment_id = p_assignment_id
3728: and effective_end_date = l_final_process_date;
3729: --
3730: l_old_abv ben_abv_ler.g_abv_ler_rec;

Line 4223: update per_assignment_budget_values_f abv

4219: l_new_abv.assignment_budget_value_id := l_c2.assignment_budget_value_id;
4220: l_new_abv.effective_start_date := l_c2.effective_start_date;
4221: l_new_abv.effective_end_date := l_effective_end_date;
4222: --
4223: update per_assignment_budget_values_f abv
4224: set abv.effective_end_date = l_effective_end_date
4225: where abv.assignment_id = c_asg_rec.assignment_id
4226: and abv.assignment_budget_value_id = l_c2.assignment_budget_value_id
4227: and abv.effective_end_date = l_final_process_date;