APPS.BEN_WHATIF_ELIG dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 3052: from per_assignment_budget_values_f abv,

3048: ) is
3049: --
3050: cursor c_asg_bud is
3051: select abv.*
3052: from per_assignment_budget_values_f abv,
3053: per_all_assignments_f asg
3054: where asg.person_id = p_person_id and
3055: asg.primary_flag = 'Y'and
3056: asg.assignment_type <> 'C' and

Line 3070: asg_bud_rec per_assignment_budget_values_f%rowtype;

3066: l_effective_end_date date;
3067: l_object_version_number number;
3068: l_upd_mode varchar2(50);
3069: --
3070: asg_bud_rec per_assignment_budget_values_f%rowtype;
3071: --
3072: begin
3073: --
3074: hr_utility.set_location(' Entering: WATIF_PER_ASG_BUDG_VAL_F_API' , 10);

Line 3102: update per_assignment_budget_values_f

3098: --
3099: null;
3100: else
3101: --
3102: update per_assignment_budget_values_f
3103: set value = asg_bud_rec.VALUE
3104: where assignment_budget_value_id = p_ASSIGNMENT_BUDGET_VALUE_ID
3105: and business_group_id = p_business_group_id
3106: and p_effective_date between effective_start_date

Line 4455: insert into per_assignment_budget_values_f

4451: fnd_message.set_name('BEN','BEN_91443_NO_ASSGN');
4452: fnd_message.raise_error;
4453: --
4454: else
4455: insert into per_assignment_budget_values_f
4456: (assignment_budget_value_id
4457: ,business_group_id
4458: ,assignment_id
4459: ,last_update_date

Line 4485: update PER_ASSIGNMENT_BUDGET_VALUES_F

4481: end if;
4482: --
4483: else
4484: --
4485: update PER_ASSIGNMENT_BUDGET_VALUES_F
4486: set VALUE = p_tpf_val
4487: where ASSIGNMENT_BUDGET_VALUE_ID = l_ASSIGNMENT_BUDGET_VALUE_ID;
4488: --
4489: end if;