42: l_first_noa_code ghr_nature_of_actions.code%type;
43: l_second_noa_code ghr_nature_of_actions.code%type;
44: l_existed BOOLEAN := FALSE;
45: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
46: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
47:
48: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
49: select code from ghr_nature_of_actions
50: where nature_of_action_id = p_noa_id;
467: p_effective_date => p_effective_date,
468: p_pa_request_id => p_pa_request_id
469: );
470: EXCEPTION
471: WHEN ghr_pay_calc.pay_calc_message THEN
472: NULL;
473: END;
474: ---------- Bug# 2569180 To avoid PL/SQL Error
475: