APPS.GHR_PROCESS_SF52 dependencies on GHR_PA_HISTORY

Line 757: FROM ghr_pa_history ghrpah_1

753: );
754: CURSOR get_root_pa_hist_id( cp_pa_request_id in number,
755: cp_noa_id in number) IS
756: SELECT min(pa_history_id)
757: FROM ghr_pa_history ghrpah_1
758: WHERE ghrpah_1.pa_request_id =
759: (SELECT min(pa_request_id)
760: FROM ghr_pa_requests
761: CONNECT BY pa_request_id = prior altered_pa_request_id

Line 1604: l_pa_history_id ghr_pa_history.pa_history_id%type;

1600: l_field_name varchar2(150);
1601: l_to_field_name varchar2(150);
1602: l_dual_actions ghr_dual_proc_methods%rowtype;
1603: l_session_var ghr_history_api.g_session_var_type;
1604: l_pa_history_id ghr_pa_history.pa_history_id%type;
1605: l_to_field varchar2(2000);
1606: l_proc varchar2(30):='copy_to_new_rg_shared';
1607:
1608: Begin