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_ACTIONS_PKG dependencies on GHR_ROUTING_GROUPS

Line 324: p_routing_group_id out nocopy ghr_routing_groups.routing_group_id%type

320: Procedure get_personnel_off_groupbox
321: (p_position_id in ghr_pa_requests.from_position_id%type,
322: p_effective_date in date default trunc(sysdate),
323: p_groupbox_id out nocopy ghr_groupboxes.groupbox_id%type,
324: p_routing_group_id out nocopy ghr_routing_groups.routing_group_id%type
325: )
326: is
327:
328: l_proc varchar2(72) := g_package || 'get_personnel_off_groupbox';

Line 331: l_routing_group_id ghr_routing_groups.routing_group_id%type;

327:
328: l_proc varchar2(72) := g_package || 'get_personnel_off_groupbox';
329: l_pos_ei_data per_position_extra_info%rowtype;
330: l_groupbox_id ghr_groupboxes.groupbox_id%type;
331: l_routing_group_id ghr_routing_groups.routing_group_id%type;
332: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
333: l_log_text varchar2(2000);
334: l_count number;
335:

Line 340: ghr_routing_groups rgp

336: Cursor c_gbx is
337: select gbx.groupbox_id gpid, gbx.routing_group_id rgpid
338: from ghr_pois gpoi,
339: ghr_groupboxes gbx,
340: ghr_routing_groups rgp
341: where gbx.groupbox_id = gpoi.groupbox_id
342: and gpoi.personnel_office_id = l_personnel_office_id
343: and gbx.routing_group_id = rgp.routing_group_id;
344: