APPS.GHR_PROCESS_SF52 dependencies on GHR_PA_HISTORY

Line 665: FROM ghr_pa_history ghrpah_1

661: );
662: CURSOR get_root_pa_hist_id( cp_pa_request_id in number,
663: cp_noa_id in number) IS
664: SELECT min(pa_history_id)
665: FROM ghr_pa_history ghrpah_1
666: WHERE ghrpah_1.pa_request_id =
667: (SELECT min(pa_request_id)
668: FROM ghr_pa_requests
669: CONNECT BY pa_request_id = prior altered_pa_request_id

Line 1512: l_pa_history_id ghr_pa_history.pa_history_id%type;

1508: l_field_name varchar2(150);
1509: l_to_field_name varchar2(150);
1510: l_dual_actions ghr_dual_proc_methods%rowtype;
1511: l_session_var ghr_history_api.g_session_var_type;
1512: l_pa_history_id ghr_pa_history.pa_history_id%type;
1513: l_to_field varchar2(2000);
1514: l_proc varchar2(30):='copy_to_new_rg_shared';
1515:
1516: Begin