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_MASS_CHANGES dependencies on GHR_PA_ROUTING_HISTORY

Line 30: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

26: l_scd_leave varchar2(30);
27: l_pa_remark_code1 ghr_remarks.code%type;
28: l_pa_remark_code2 ghr_remarks.code%type;
29: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
30: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
31: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
32: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
33: l_multiple_error_flag boolean;
34: l_dummy varchar2(30);

Line 32: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

28: l_pa_remark_code2 ghr_remarks.code%type;
29: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
30: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
31: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
32: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
33: l_multiple_error_flag boolean;
34: l_dummy varchar2(30);
35: l_remark_id ghr_remarks.remark_id%type;
36: l_description ghr_remarks.description%type;

Line 45: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

41: l_log_text varchar2(2000);
42: l_route_flag varchar2(1);
43: l_routing_group_id ghr_pa_requests.routing_group_id%type;
44: l_groupbox_id ghr_groupboxes.groupbox_id%type;
45: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
46: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
47: l_personnel_office_id ghr_pois.personnel_office_id%type;
48: l_personnel_officer_name per_people_f.full_name%type;
49: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;

Line 117: from ghr_pa_routing_history prh

113:
114: Cursor c_routing_history is
115: select prh.pa_routing_history_id,
116: prh.object_version_number
117: from ghr_pa_routing_history prh
118: where prh.pa_request_id = l_pa_request_rec.pa_request_id
119: order by 1 desc;
120:
121: --7577249