DBA Data[Home] [Help]

APPS.HR_CONTINGENT_WORKER_API dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 3304: from per_assignment_budget_values_f

3300: -- Start of Fix for WWBUG 1408379
3301: --
3302: cursor c2(p_assignment_id number) is
3303: select *
3304: from per_assignment_budget_values_f
3305: where assignment_id = p_assignment_id
3306: and effective_end_date = l_final_process_date;
3307: --
3308: l_old_abv ben_abv_ler.g_abv_ler_rec;

Line 3766: update per_assignment_budget_values_f abv

3762: l_new_abv.assignment_budget_value_id := l_c2.assignment_budget_value_id;
3763: l_new_abv.effective_start_date := l_c2.effective_start_date;
3764: l_new_abv.effective_end_date := l_effective_end_date;
3765: --
3766: update per_assignment_budget_values_f abv
3767: set abv.effective_end_date = l_effective_end_date
3768: where abv.assignment_id = c_asg_rec.assignment_id
3769: and abv.assignment_budget_value_id = l_c2.assignment_budget_value_id
3770: and abv.effective_end_date = l_final_process_date;