APPS.HREMPTER dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 393: from per_assignment_budget_values_f abv

389: l_new ben_abv_ler.g_abv_ler_rec;
390: --
391: cursor c1 is
392: select *
393: from per_assignment_budget_values_f abv
394: where abv.assignment_id = p_assignment_id
395: and p_final_process_date
396: between abv.effective_start_date
397: and abv.effective_end_date;

Line 462: DELETE per_assignment_budget_values_f abv

458: -- Due to date tracking of assignment_budget_values.
459: -- SASmith 30-APR-1998
460:
461: hr_utility.set_location(l_proc,40);
462: DELETE per_assignment_budget_values_f abv
463: WHERE abv.assignment_id = p_assignment_id
464: AND abv.effective_start_date > p_final_process_date;
465: --
466: hr_utility.set_location(l_proc,45);

Line 490: update per_assignment_budget_values_f abv

486: l_new.assignment_budget_value_id := l_c1.assignment_budget_value_id;
487: l_new.effective_start_date := l_c1.effective_start_date;
488: l_new.effective_end_date := p_final_process_date;
489: --
490: update per_assignment_budget_values_f abv
491: set abv.effective_end_date = p_final_process_date
492: where abv.assignment_budget_value_id = l_c1.assignment_budget_value_id
493: and abv.effective_start_date = l_c1.effective_start_date
494: and abv.effective_end_date = l_c1.effective_end_date;

Line 3428: from per_assignment_budget_values_f

3424: -- Start of Fix for WWBUG 1408379
3425: --
3426: cursor c2(p_assignment_id number) is
3427: select *
3428: from per_assignment_budget_values_f
3429: where assignment_id = p_assignment_id
3430: and effective_end_date = l_final_process_date;
3431: --
3432: l_old_abv ben_abv_ler.g_abv_ler_rec;

Line 4127: update per_assignment_budget_values_f abv

4123: l_new_abv.assignment_budget_value_id := l_c2.assignment_budget_value_id;
4124: l_new_abv.effective_start_date := l_c2.effective_start_date;
4125: l_new_abv.effective_end_date := l_effective_end_date;
4126: --
4127: update per_assignment_budget_values_f abv
4128: set abv.effective_end_date = l_effective_end_date
4129: where abv.assignment_id = c_ass_rec.assignment_id
4130: and abv.assignment_budget_value_id = l_c2.assignment_budget_value_id
4131: and abv.effective_end_date = l_final_process_date;