APPS.HREMPTER dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 405: from per_assignment_budget_values_f abv

401: l_new ben_abv_ler.g_abv_ler_rec;
402: --
403: cursor c1 is
404: select *
405: from per_assignment_budget_values_f abv
406: where abv.assignment_id = p_assignment_id
407: and p_final_process_date
408: between abv.effective_start_date
409: and abv.effective_end_date;

Line 474: DELETE per_assignment_budget_values_f abv

470: -- Due to date tracking of assignment_budget_values.
471: -- SASmith 30-APR-1998
472:
473: hr_utility.set_location(l_proc,40);
474: DELETE per_assignment_budget_values_f abv
475: WHERE abv.assignment_id = p_assignment_id
476: AND abv.effective_start_date > p_final_process_date;
477: --
478: hr_utility.set_location(l_proc,45);

Line 502: update per_assignment_budget_values_f abv

498: l_new.assignment_budget_value_id := l_c1.assignment_budget_value_id;
499: l_new.effective_start_date := l_c1.effective_start_date;
500: l_new.effective_end_date := p_final_process_date;
501: --
502: update per_assignment_budget_values_f abv
503: set abv.effective_end_date = p_final_process_date
504: where abv.assignment_budget_value_id = l_c1.assignment_budget_value_id
505: and abv.effective_start_date = l_c1.effective_start_date
506: and abv.effective_end_date = l_c1.effective_end_date;

Line 3472: from per_assignment_budget_values_f

3468: -- Start of Fix for WWBUG 1408379
3469: --
3470: cursor c2(p_assignment_id number) is
3471: select *
3472: from per_assignment_budget_values_f
3473: where assignment_id = p_assignment_id
3474: and effective_end_date = l_final_process_date;
3475: --
3476: l_old_abv ben_abv_ler.g_abv_ler_rec;

Line 4277: update per_assignment_budget_values_f abv

4273: l_new_abv.assignment_budget_value_id := l_c2.assignment_budget_value_id;
4274: l_new_abv.effective_start_date := l_c2.effective_start_date;
4275: l_new_abv.effective_end_date := l_effective_end_date;
4276: --
4277: update per_assignment_budget_values_f abv
4278: set abv.effective_end_date = l_effective_end_date
4279: where abv.assignment_id = c_ass_rec.assignment_id
4280: and abv.assignment_budget_value_id = l_c2.assignment_budget_value_id
4281: and abv.effective_end_date = l_final_process_date;