687: ,p_noa_code OUT NOCOPY VARCHAR2) IS
688:
689: CURSOR cur_noa_code IS
690: SELECT rpa.first_noa_code 691: FROM ghr_pa_requests rpa 692: WHERE rpa.pa_request_id = p_pa_request_id;
693:
694: BEGIN
695: --
Line 709: FROM ghr_pa_requests rpa
705: ,p_second_noa_code OUT NOCOPY VARCHAR2) IS
706:
707: CURSOR cur_second_noa_code IS
708: SELECT rpa.second_noa_code 709: FROM ghr_pa_requests rpa 710: WHERE rpa.pa_request_id = p_pa_request_id;
711:
712: BEGIN
713: --