DBA Data[Home] [Help]

APPS.GHR_MTO_INT dependencies on PER_ASSIGNMENTS_F

Line 1817: l_table_name constant varchar2(30) := 'PER_ASSIGNMENTS_F';

1813: p_a per_all_assignments_f%rowtype)
1814: is
1815:
1816: l_proc varchar2(72) := g_package||'insert_assignment';
1817: l_table_name constant varchar2(30) := 'PER_ASSIGNMENTS_F';
1818: l_name varchar2(30);
1819:
1820: begin
1821:

Line 4027: l_position_id per_assignments_f.position_id%type;

4023: l_effdate date;
4024: l_transfer_name ghr_mass_transfers.name%type;
4025: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4026:
4027: l_position_id per_assignments_f.position_id%type;
4028: l_location_id per_assignments_f.location_id%type;
4029: l_assignment_id per_assignments_f.assignment_id%type;
4030: l_grade_id per_assignments_f.grade_id%type;
4031: l_business_group_id per_assignments_f.business_group_id%type;

Line 4028: l_location_id per_assignments_f.location_id%type;

4024: l_transfer_name ghr_mass_transfers.name%type;
4025: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4026:
4027: l_position_id per_assignments_f.position_id%type;
4028: l_location_id per_assignments_f.location_id%type;
4029: l_assignment_id per_assignments_f.assignment_id%type;
4030: l_grade_id per_assignments_f.grade_id%type;
4031: l_business_group_id per_assignments_f.business_group_id%type;
4032:

Line 4029: l_assignment_id per_assignments_f.assignment_id%type;

4025: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4026:
4027: l_position_id per_assignments_f.position_id%type;
4028: l_location_id per_assignments_f.location_id%type;
4029: l_assignment_id per_assignments_f.assignment_id%type;
4030: l_grade_id per_assignments_f.grade_id%type;
4031: l_business_group_id per_assignments_f.business_group_id%type;
4032:
4033: l_pos_ei_data per_position_extra_info%rowtype;

Line 4030: l_grade_id per_assignments_f.grade_id%type;

4026:
4027: l_position_id per_assignments_f.position_id%type;
4028: l_location_id per_assignments_f.location_id%type;
4029: l_assignment_id per_assignments_f.assignment_id%type;
4030: l_grade_id per_assignments_f.grade_id%type;
4031: l_business_group_id per_assignments_f.business_group_id%type;
4032:
4033: l_pos_ei_data per_position_extra_info%rowtype;
4034: l_per_ei_data per_people_extra_info%rowtype;

Line 4031: l_business_group_id per_assignments_f.business_group_id%type;

4027: l_position_id per_assignments_f.position_id%type;
4028: l_location_id per_assignments_f.location_id%type;
4029: l_assignment_id per_assignments_f.assignment_id%type;
4030: l_grade_id per_assignments_f.grade_id%type;
4031: l_business_group_id per_assignments_f.business_group_id%type;
4032:
4033: l_pos_ei_data per_position_extra_info%rowtype;
4034: l_per_ei_data per_people_extra_info%rowtype;
4035: l_asg_ei_data per_assignment_extra_info%rowtype;