790: l_pos_extra_info_rec per_position_extra_info%rowtype;
791: l_proc varchar2(70) := 'Retrieve_all_extra_info';
792: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
793: l_position_id per_positions.position_id%type;
794: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
795: l_session ghr_history_api.g_session_var_type;
796: l_person_status per_assignment_status_types.user_status%type;
797:
798: -- Bug 3021003
1163: -- Bug 3021003 If Intervening actions are present in WGI, QSI corrections, get the corrected step.
1164: -- Bug 4658890 Removed 894 from first_noa_code
1165: IF p_pa_request_rec.first_noa_code IN ('867','892','893') AND l_session.noa_id_correct IS NOT NULL THEN
1166: hr_utility.set_location('Inside PRUP Sun if condn',10);
1167: ghr_pay_calc.is_retained_ia(p_pa_request_rec.person_id,
1168: p_pa_request_rec.effective_date,
1169: l_retained_grade_rec.pay_plan,
1170: l_retained_grade_rec.grade_or_level,
1171: l_retained_grade_rec.step_or_rate,
1188: -- Need to handle this Exception here because it is just a warning to indicate that the pay cannot be calculated
1189: -- which is only apt for the Front End and does not matter in this context.
1190:
1191: exception
1192: when ghr_pay_calc.pay_calc_message then
1193: null;
1194: end;
1195:
1196: -- Retrieve per_separate_retire
1789:
1790: -- Added for the bug # 6881863
1791: -- to fetch the pay table identifier from position if it getting as NULL if PRD is K or J
1792: 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
1793: l_calc_table_id := ghr_pay_calc.get_user_table_id(p_position_id => p_pa_request_rec.to_position_id,
1794: p_effective_date => p_pa_request_rec.effective_date);
1795: p_asg_sf52.asg_sf52_flag := 'Y';
1796: P_Asg_Sf52.calc_pay_table := l_calc_table_id;
1797: END IF;