696: ,p_noa_code OUT NOCOPY VARCHAR2) IS
697:
698: CURSOR cur_noa_code IS
699: SELECT rpa.first_noa_code 700: FROM ghr_pa_requests rpa 701: WHERE rpa.pa_request_id = p_pa_request_id;
702:
703: BEGIN
704: --
Line 718: FROM ghr_pa_requests rpa
714: ,p_second_noa_code OUT NOCOPY VARCHAR2) IS
715:
716: CURSOR cur_second_noa_code IS
717: SELECT rpa.second_noa_code 718: FROM ghr_pa_requests rpa 719: WHERE rpa.pa_request_id = p_pa_request_id;
720:
721: BEGIN
722: --