APPS.BEN_WHATIF_ELIG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1073: per_assign_rec per_all_assignments_f%rowtype;

1069: ,p_business_group_id in number
1070: ,p_effective_date in date
1071: ) is
1072: --
1073: per_assign_rec per_all_assignments_f%rowtype;
1074: --
1075: cursor c_assign is
1076: select * from per_all_assignments_f
1077: where person_id = p_person_id and

Line 1076: select * from per_all_assignments_f

1072: --
1073: per_assign_rec per_all_assignments_f%rowtype;
1074: --
1075: cursor c_assign is
1076: select * from per_all_assignments_f
1077: where person_id = p_person_id and
1078: assignment_type <> 'C' and
1079: p_effective_date between nvl(effective_start_date, p_effective_date)
1080: and nvl(effective_end_date, p_effective_date)

Line 1101: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;

1097: l_org_now_no_manager_warning boolean;
1098: l_spp_delete_warning boolean;
1099: l_entries_changed_warning varchar2(30);
1100: l_tax_district_changed_warning boolean;
1101: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;
1102: --
1103: begin
1104: --
1105: hr_utility.set_location(' Entering: WATIF_ALL_ASSIGNMENTS_F_API' , 10);

Line 1298: p_base_table_name => 'PER_ALL_ASSIGNMENTS_F',

1294: end if;
1295: --
1296: Get_DT_Upd_Mode
1297: (p_effective_date => p_effective_date,
1298: p_base_table_name => 'PER_ALL_ASSIGNMENTS_F',
1299: p_base_key_column => 'ASSIGNMENT_ID',
1300: p_base_key_value => per_assign_rec.assignment_id,
1301: p_mode => l_upd_mode);
1302: --

Line 1498: p_base_table_name => 'PER_ALL_ASSIGNMENTS_F',

1494: end if;
1495:
1496: Get_DT_Upd_Mode
1497: (p_effective_date => p_effective_date,
1498: p_base_table_name => 'PER_ALL_ASSIGNMENTS_F',
1499: p_base_key_column => 'ASSIGNMENT_ID',
1500: p_base_key_value => per_assign_rec.assignment_id,
1501: p_mode => l_upd_mode);
1502:

Line 3053: per_all_assignments_f asg

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
3057: p_effective_date between nvl(asg.effective_start_date, p_effective_date)

Line 4039: from per_all_assignments_f

4035: cursor c_pay_rec is
4036: select * from per_pay_proposals pyp
4037: where pyp.assignment_id in
4038: (select assignment_id
4039: from per_all_assignments_f
4040: where person_id = p_person_id
4041: and business_group_id = p_business_group_id)
4042: and pyp.business_group_id = p_business_group_id
4043: and p_change_date = pyp.change_date;

Line 4046: select assignment_id from per_all_assignments_f

4042: and pyp.business_group_id = p_business_group_id
4043: and p_change_date = pyp.change_date;
4044:
4045: cursor c_assignment_id is
4046: select assignment_id from per_all_assignments_f
4047: where person_id = p_person_id
4048: and business_group_id = p_business_group_id;
4049:
4050: l_assignment_id number;