DBA Data[Home] [Help]

APPS.GHR_MTO_INT dependencies on PER_ASSIGNMENTS_F

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

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

Line 4028: l_position_id per_assignments_f.position_id%type;

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

Line 4029: l_location_id per_assignments_f.location_id%type;

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

Line 4030: l_assignment_id per_assignments_f.assignment_id%type;

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

Line 4031: l_grade_id per_assignments_f.grade_id%type;

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

Line 4032: l_business_group_id per_assignments_f.business_group_id%type;

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