[Home] [Help]
810: l_pos_extra_info_rec per_position_extra_info%rowtype;
811: l_proc varchar2(70) := 'Retrieve_all_extra_info';
812: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
813: l_position_id per_positions.position_id%type;
814: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
815: l_session ghr_history_api.g_session_var_type;
816: l_person_status per_assignment_status_types.user_status%type;
817:
818: -- Bug 3021003
1262: -- Bug 3021003 If Intervening actions are present in WGI, QSI corrections, get the corrected step.
1263: -- Bug 4658890 Removed 894 from first_noa_code
1264: IF p_pa_request_rec.first_noa_code IN ('867','892','893') AND l_session.noa_id_correct IS NOT NULL THEN
1265: hr_utility.set_location('Inside PRUP Sun if condn',10);
1266: ghr_pay_calc.is_retained_ia(p_pa_request_rec.person_id,
1267: p_pa_request_rec.effective_date,
1268: l_retained_grade_rec.pay_plan,
1269: l_retained_grade_rec.grade_or_level,
1270: l_retained_grade_rec.step_or_rate,
1287: -- Need to handle this Exception here because it is just a warning to indicate that the pay cannot be calculated
1288: -- which is only apt for the Front End and does not matter in this context.
1289:
1290: exception
1291: when ghr_pay_calc.pay_calc_message then
1292: null;
1293: end;
1294:
1295: -- Retrieve per_separate_retire
1888:
1889: -- Added for the bug # 6881863
1890: -- to fetch the pay table identifier from position if it getting as NULL if PRD is K or J
1891: IF p_pa_request_rec.to_pay_table_identifier is null and NVL(p_pa_request_rec.pay_rate_determinant,'X') in ('K','J') then
1892: l_calc_table_id := ghr_pay_calc.get_user_table_id(p_position_id => p_pa_request_rec.to_position_id,
1893: p_effective_date => p_pa_request_rec.effective_date);
1894: --Bug# 13587903, added below if condition not to update calc pay table every time
1895: IF nvl(p_asg_sf52.calc_pay_table,hr_api.g_number) <> l_calc_table_id THEN
1896: hr_utility.set_location(l_proc,40);