eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_SS_RPA_CREATION dependencies on GHR_PA_ROUTING_HISTORY

Line 269: FROM ghr_pa_routing_history prh

265: CURSOR c_routing_history(p_pa_request_id in number)
266: IS
267: SELECT prh.pa_routing_history_id,
268: prh.object_version_number
269: FROM ghr_pa_routing_history prh
270: WHERE prh.pa_request_id = p_pa_request_id
271: ORDER BY 1 desc;
272:
273: l_sf52_rec ghr_pa_requests%rowtype;

Line 274: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

270: WHERE prh.pa_request_id = p_pa_request_id
271: ORDER BY 1 desc;
272:
273: l_sf52_rec ghr_pa_requests%rowtype;
274: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
275: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
276: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
277: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
278: l_object_version_number ghr_pa_remarks.object_version_number%type;

Line 277: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

273: l_sf52_rec ghr_pa_requests%rowtype;
274: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
275: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
276: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
277: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
278: l_object_version_number ghr_pa_remarks.object_version_number%type;
279: l_full_name VARCHAR2(380);
280: l_employee_number per_people_f.employee_number%type;
281: l_routing_group_id ghr_pa_requests.routing_group_id%type;

Line 288: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

284: l_log_text varchar2(2000);
285: l_dummy_char varchar2(150);
286: l_personnel_officer_name per_people_f.full_name%type;
287: l_groupbox_id ghr_groupboxes.groupbox_id%type;
288: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
289: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
290: l_scd_leave varchar2(50);
291: l_multiple_error_flag boolean;
292: l_proc varchar2(72) := g_package || 'create_sf52_fegli_rpa';

Line 962: FROM ghr_pa_routing_history prh

958: CURSOR c_routing_history(p_pa_request_id in number)
959: IS
960: SELECT prh.pa_routing_history_id,
961: prh.object_version_number
962: FROM ghr_pa_routing_history prh
963: WHERE prh.pa_request_id = p_pa_request_id
964: ORDER BY 1 desc;
965:
966: l_uprh_object_version_number ghr_pa_routing_history.object_version_number%type;

Line 966: l_uprh_object_version_number ghr_pa_routing_history.object_version_number%type;

962: FROM ghr_pa_routing_history prh
963: WHERE prh.pa_request_id = p_pa_request_id
964: ORDER BY 1 desc;
965:
966: l_uprh_object_version_number ghr_pa_routing_history.object_version_number%type;
967: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
968: l_iprh_object_version_number ghr_pa_routing_history.object_version_number%type;
969: l_sf52_rec ghr_pa_requests%rowtype;
970: l_full_name VARCHAR2(380);

Line 967: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

963: WHERE prh.pa_request_id = p_pa_request_id
964: ORDER BY 1 desc;
965:
966: l_uprh_object_version_number ghr_pa_routing_history.object_version_number%type;
967: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
968: l_iprh_object_version_number ghr_pa_routing_history.object_version_number%type;
969: l_sf52_rec ghr_pa_requests%rowtype;
970: l_full_name VARCHAR2(380);
971: l_employee_number per_people_f.employee_number%type;

Line 968: l_iprh_object_version_number ghr_pa_routing_history.object_version_number%type;

964: ORDER BY 1 desc;
965:
966: l_uprh_object_version_number ghr_pa_routing_history.object_version_number%type;
967: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
968: l_iprh_object_version_number ghr_pa_routing_history.object_version_number%type;
969: l_sf52_rec ghr_pa_requests%rowtype;
970: l_full_name VARCHAR2(380);
971: l_employee_number per_people_f.employee_number%type;
972: l_routing_group_id ghr_pa_requests.routing_group_id%type;