APPS.BEN_WHATIF_ELIG dependencies on PER_ASSIGNMENT_BUDGET_VALUES

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 4351: per_assignment_budget_values pab

4347: cursor c_exist_fte is
4348: select pab.ASSIGNMENT_BUDGET_VALUE_ID
4349: from per_all_people_f per,
4350: per_assignments_f paf,
4351: per_assignment_budget_values pab
4352: where per.person_id = p_person_id
4353: and paf.assignment_type <> 'C'
4354: and p_effective_date
4355: between per.effective_start_date

Line 4427: if a record in the per_assignment_budget_values exists then

4423: if p_temporal_lf_evt = 'TPF' then
4424: --
4425: null;
4426: /* set use primary assignment flag = y, and other flags = n;
4427: if a record in the per_assignment_budget_values exists then
4428: change all non primary ones to 0;
4429: change primary one to the value entered by the user;
4430: else
4431: create a record in the per_assignment_budget values if

Line 4431: create a record in the per_assignment_budget values if

4427: if a record in the per_assignment_budget_values exists then
4428: change all non primary ones to 0;
4429: change primary one to the value entered by the user;
4430: else
4431: create a record in the per_assignment_budget values if
4432: a primary assignment exists else error out;
4433: end if;
4434: */
4435: -- 9999 do I need to worry about mn_pct_val etc.,

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 4469: per_assignment_budget_values_s.nextval

4465: ,value
4466: ,effective_start_date
4467: ,effective_end_date)
4468: values (
4469: per_assignment_budget_values_s.nextval
4470: ,l_assign.business_group_id
4471: ,l_assign.assignment_id
4472: ,sysdate
4473: ,null

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;