[Home] [Help]
6: ,p_old_pa_request_id IN NUMBER)
7: IS
8: CURSOR c_rei IS
9: SELECT *
10: FROM ghr_pa_request_extra_info
11: WHERE pa_request_id = p_old_pa_request_id;
12: v_ovn NUMBER;
13: v_pa_request_extra_info_id NUMBER;
14: l_proc varchar2(61) := g_package_name || 'CREATE_PA_REQUEST_EXTRA_INFO';