DBA Data[Home] [Help]

APPS.GHR_PER_SUM dependencies on GHR_PA_REQUESTS

Line 691: FROM ghr_pa_requests rpa

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