DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on PER_POSITION_EXTRA_INFO

Line 297: l_pos_ei_data per_position_extra_info%rowtype;

293: l_errbuf varchar2(2000);
294:
295: l_retcode number;
296:
297: l_pos_ei_data per_position_extra_info%rowtype;
298: l_pos_grp1_rec per_position_extra_info%rowtype;
299:
300: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
301: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 298: l_pos_grp1_rec per_position_extra_info%rowtype;

294:
295: l_retcode number;
296:
297: l_pos_ei_data per_position_extra_info%rowtype;
298: l_pos_grp1_rec per_position_extra_info%rowtype;
299:
300: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
301: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
302: l_sel_flg varchar2(2);

Line 2165: l_pos_ei_data per_position_extra_info%rowtype;

2161:
2162: p_person_extra_info_id number;
2163: ----p_locality_percent number; --- AVR 12/08/98
2164:
2165: l_pos_ei_data per_position_extra_info%rowtype;
2166: l_asg_ei_data per_assignment_extra_info%rowtype;
2167:
2168: cursor c_grade_kff (grd_id number) is
2169: select gdf.segment1

Line 2343: l_pos_ei_data per_position_extra_info%rowtype;

2339:
2340: p_person_extra_info_id number;
2341: --p_locality_percent number; --- AVR 12/08/98
2342:
2343: l_pos_ei_data per_position_extra_info%rowtype;
2344: l_asg_ei_data per_assignment_extra_info%rowtype;
2345:
2346:
2347: cursor c_grade_kff (grd_id number) is

Line 2866: l_pos_grp1_rec per_position_extra_info%rowtype;

2862: AND pay_plan = cur_pay_plan
2863: AND pay_rate_determinant = cur_prd;
2864:
2865: l_row_cnt NUMBER := 0;
2866: l_pos_grp1_rec per_position_extra_info%rowtype;
2867: l_assignment_id per_assignments_f.assignment_id%TYPE;
2868: l_person_id per_assignments_f.person_id%TYPE;
2869: l_position_id per_assignments_f.position_id%TYPE;
2870: l_grade_id per_assignments_f.grade_id%TYPE;

Line 3231: l_pos_grp1_rec per_position_extra_info%rowtype;

3227: AND pay_plan = cur_pay_plan
3228: AND pay_rate_determinant = cur_prd;
3229:
3230: l_row_cnt NUMBER := 0;
3231: l_pos_grp1_rec per_position_extra_info%rowtype;
3232: l_assignment_id per_assignments_f.assignment_id%TYPE;
3233: l_person_id per_assignments_f.person_id%TYPE;
3234: l_position_id per_assignments_f.position_id%TYPE;
3235: l_grade_id per_assignments_f.grade_id%TYPE;

Line 3945: p_pos_ei_data out nocopy per_position_extra_info%rowtype)

3941: --
3942:
3943: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
3944: p_effective_date in date,
3945: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3946: IS
3947:
3948: l_proc varchar2(72) := g_package || '.get_pos_grp1_ddf';
3949: --l_pos_ei_data per_position_extra_info%type;

Line 3949: --l_pos_ei_data per_position_extra_info%type;

3945: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3946: IS
3947:
3948: l_proc varchar2(72) := g_package || '.get_pos_grp1_ddf';
3949: --l_pos_ei_data per_position_extra_info%type;
3950:
3951: begin
3952: g_proc := 'get_pos_grp1_ddf';
3953: hr_utility.set_location('Entering ' || l_proc,5);

Line 5192: l_pos_ei_data per_position_extra_info%rowtype;

5188: l_errbuf varchar2(2000);
5189:
5190: l_retcode number;
5191:
5192: l_pos_ei_data per_position_extra_info%rowtype;
5193: l_pos_grp1_rec per_position_extra_info%rowtype;
5194:
5195: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
5196: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 5193: l_pos_grp1_rec per_position_extra_info%rowtype;

5189:
5190: l_retcode number;
5191:
5192: l_pos_ei_data per_position_extra_info%rowtype;
5193: l_pos_grp1_rec per_position_extra_info%rowtype;
5194:
5195: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
5196: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
5197: l_sel_flg varchar2(2);

Line 6763: l_pos_grp1_rec per_position_extra_info%rowtype;

6759: AND pay_plan = cur_pay_plan
6760: AND pay_rate_determinant = cur_prd;
6761:
6762: l_row_cnt NUMBER := 0;
6763: l_pos_grp1_rec per_position_extra_info%rowtype;
6764: l_assignment_id per_assignments_f.assignment_id%TYPE;
6765: l_person_id per_assignments_f.person_id%TYPE;
6766: l_position_id per_assignments_f.position_id%TYPE;
6767: l_grade_id per_assignments_f.grade_id%TYPE;

Line 7333: l_pos_ei_data per_position_extra_info%rowtype;

7329: l_errbuf varchar2(2000);
7330:
7331: l_retcode number;
7332:
7333: l_pos_ei_data per_position_extra_info%rowtype;
7334: l_pos_grp1_rec per_position_extra_info%rowtype;
7335:
7336: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
7337: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 7334: l_pos_grp1_rec per_position_extra_info%rowtype;

7330:
7331: l_retcode number;
7332:
7333: l_pos_ei_data per_position_extra_info%rowtype;
7334: l_pos_grp1_rec per_position_extra_info%rowtype;
7335:
7336: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
7337: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
7338: l_sel_flg varchar2(2);