DBA Data[Home] [Help]

APPS.GHR_PER_SUM dependencies on GHR_PA_REQUESTS

Line 700: FROM ghr_pa_requests rpa

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: --