DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on PER_POSITION_EXTRA_INFO

Line 293: l_pos_ei_data per_position_extra_info%rowtype;

289: l_errbuf varchar2(2000);
290:
291: l_retcode number;
292:
293: l_pos_ei_data per_position_extra_info%rowtype;
294: l_pos_grp1_rec per_position_extra_info%rowtype;
295:
296: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
297: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 294: l_pos_grp1_rec per_position_extra_info%rowtype;

290:
291: l_retcode number;
292:
293: l_pos_ei_data per_position_extra_info%rowtype;
294: l_pos_grp1_rec per_position_extra_info%rowtype;
295:
296: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
297: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
298: l_sel_flg varchar2(2);

Line 2137: l_pos_ei_data per_position_extra_info%rowtype;

2133:
2134: p_person_extra_info_id number;
2135: ----p_locality_percent number; --- AVR 12/08/98
2136:
2137: l_pos_ei_data per_position_extra_info%rowtype;
2138: l_asg_ei_data per_assignment_extra_info%rowtype;
2139:
2140: cursor c_grade_kff (grd_id number) is
2141: select gdf.segment1

Line 2315: l_pos_ei_data per_position_extra_info%rowtype;

2311:
2312: p_person_extra_info_id number;
2313: --p_locality_percent number; --- AVR 12/08/98
2314:
2315: l_pos_ei_data per_position_extra_info%rowtype;
2316: l_asg_ei_data per_assignment_extra_info%rowtype;
2317:
2318:
2319: cursor c_grade_kff (grd_id number) is

Line 2836: l_pos_grp1_rec per_position_extra_info%rowtype;

2832: AND pay_plan = cur_pay_plan
2833: AND pay_rate_determinant = cur_prd;
2834:
2835: l_row_cnt NUMBER := 0;
2836: l_pos_grp1_rec per_position_extra_info%rowtype;
2837: l_assignment_id per_assignments_f.assignment_id%TYPE;
2838: l_person_id per_assignments_f.person_id%TYPE;
2839: l_position_id per_assignments_f.position_id%TYPE;
2840: l_grade_id per_assignments_f.grade_id%TYPE;

Line 3198: l_pos_grp1_rec per_position_extra_info%rowtype;

3194: AND pay_plan = cur_pay_plan
3195: AND pay_rate_determinant = cur_prd;
3196:
3197: l_row_cnt NUMBER := 0;
3198: l_pos_grp1_rec per_position_extra_info%rowtype;
3199: l_assignment_id per_assignments_f.assignment_id%TYPE;
3200: l_person_id per_assignments_f.person_id%TYPE;
3201: l_position_id per_assignments_f.position_id%TYPE;
3202: l_grade_id per_assignments_f.grade_id%TYPE;

Line 3893: p_pos_ei_data out nocopy per_position_extra_info%rowtype)

3889: --
3890:
3891: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
3892: p_effective_date in date,
3893: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3894: IS
3895:
3896: l_proc varchar2(72) := g_package || '.get_pos_grp1_ddf';
3897: --l_pos_ei_data per_position_extra_info%type;

Line 3897: --l_pos_ei_data per_position_extra_info%type;

3893: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3894: IS
3895:
3896: l_proc varchar2(72) := g_package || '.get_pos_grp1_ddf';
3897: --l_pos_ei_data per_position_extra_info%type;
3898:
3899: begin
3900: g_proc := 'get_pos_grp1_ddf';
3901: hr_utility.set_location('Entering ' || l_proc,5);

Line 5130: l_pos_ei_data per_position_extra_info%rowtype;

5126: l_errbuf varchar2(2000);
5127:
5128: l_retcode number;
5129:
5130: l_pos_ei_data per_position_extra_info%rowtype;
5131: l_pos_grp1_rec per_position_extra_info%rowtype;
5132:
5133: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
5134: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 5131: l_pos_grp1_rec per_position_extra_info%rowtype;

5127:
5128: l_retcode number;
5129:
5130: l_pos_ei_data per_position_extra_info%rowtype;
5131: l_pos_grp1_rec per_position_extra_info%rowtype;
5132:
5133: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
5134: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
5135: l_sel_flg varchar2(2);

Line 6622: l_pos_grp1_rec per_position_extra_info%rowtype;

6618: AND pay_plan = cur_pay_plan
6619: AND pay_rate_determinant = cur_prd;
6620:
6621: l_row_cnt NUMBER := 0;
6622: l_pos_grp1_rec per_position_extra_info%rowtype;
6623: l_assignment_id per_assignments_f.assignment_id%TYPE;
6624: l_person_id per_assignments_f.person_id%TYPE;
6625: l_position_id per_assignments_f.position_id%TYPE;
6626: l_grade_id per_assignments_f.grade_id%TYPE;

Line 7187: l_pos_ei_data per_position_extra_info%rowtype;

7183: l_errbuf varchar2(2000);
7184:
7185: l_retcode number;
7186:
7187: l_pos_ei_data per_position_extra_info%rowtype;
7188: l_pos_grp1_rec per_position_extra_info%rowtype;
7189:
7190: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
7191: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 7188: l_pos_grp1_rec per_position_extra_info%rowtype;

7184:
7185: l_retcode number;
7186:
7187: l_pos_ei_data per_position_extra_info%rowtype;
7188: l_pos_grp1_rec per_position_extra_info%rowtype;
7189:
7190: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
7191: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
7192: l_sel_flg varchar2(2);