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

Line 62: l_routing_group_name ghr_routing_groups.name%TYPE;

58: l_effective_date ghr_pa_requests.effective_date%TYPE;
59: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
60: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
61: l_full_name per_people_f.full_name%TYPE;
62: l_routing_group_name ghr_routing_groups.name%TYPE;
63: l_routing_group_desc ghr_routing_groups.description%TYPE;
64: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
65: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
66: l_groupbox_name ghr_groupboxes.name%TYPE;

Line 63: l_routing_group_desc ghr_routing_groups.description%TYPE;

59: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
60: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
61: l_full_name per_people_f.full_name%TYPE;
62: l_routing_group_name ghr_routing_groups.name%TYPE;
63: l_routing_group_desc ghr_routing_groups.description%TYPE;
64: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
65: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
66: l_groupbox_name ghr_groupboxes.name%TYPE;
67: l_groupbox_desc ghr_groupboxes.description%TYPE;

Line 382: l_routing_group_name ghr_routing_groups.name%TYPE;

378: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
379: l_groupbox_name ghr_groupboxes.name%TYPE;
380: l_groupbox_desc ghr_groupboxes.name%TYPE;
381: l_routing_group_id ghr_groupboxes.routing_group_id%TYPE;
382: l_routing_group_name ghr_routing_groups.name%TYPE;
383: l_routing_group_desc ghr_routing_groups.description%TYPE;
384: --
385: --
386: cursor csr_gbx is

Line 383: l_routing_group_desc ghr_routing_groups.description%TYPE;

379: l_groupbox_name ghr_groupboxes.name%TYPE;
380: l_groupbox_desc ghr_groupboxes.name%TYPE;
381: l_routing_group_id ghr_groupboxes.routing_group_id%TYPE;
382: l_routing_group_name ghr_routing_groups.name%TYPE;
383: l_routing_group_desc ghr_routing_groups.description%TYPE;
384: --
385: --
386: cursor csr_gbx is
387: select gbx.groupbox_id, gbx.routing_group_id, gbx.name, rgp.name , rgp.description

Line 388: from ghr_groupboxes gbx, ghr_routing_groups rgp

384: --
385: --
386: cursor csr_gbx is
387: select gbx.groupbox_id, gbx.routing_group_id, gbx.name, rgp.name , rgp.description
388: from ghr_groupboxes gbx, ghr_routing_groups rgp
389: where gbx.name = l_groupbox_name
390: and gbx.routing_group_id = rgp.routing_group_id;
391: --
392: begin

Line 803: l_routing_group_name ghr_routing_groups.name%TYPE;

799: l_new_sal ghr_pa_requests.to_total_salary%type;
800: l_positionei_rec per_position_extra_info%rowtype;
801: l_special_info ghr_api.special_information_type;
802: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
803: l_routing_group_name ghr_routing_groups.name%TYPE;
804: l_rgp_description ghr_routing_groups.description%TYPE;
805: --
806: --
807: cursor csr_lkp_code( l_type in varchar2,

Line 804: l_rgp_description ghr_routing_groups.description%TYPE;

800: l_positionei_rec per_position_extra_info%rowtype;
801: l_special_info ghr_api.special_information_type;
802: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
803: l_routing_group_name ghr_routing_groups.name%TYPE;
804: l_rgp_description ghr_routing_groups.description%TYPE;
805: --
806: --
807: cursor csr_lkp_code( l_type in varchar2,
808: l_code in varchar2) is

Line 837: FROM ghr_routing_groups rgp, ghr_pa_requests par

833: --
834: --
835: cursor csr_rgp is
836: SELECT rgp.name, rgp.description
837: FROM ghr_routing_groups rgp, ghr_pa_requests par
838: WHERE par.pa_request_id = p_request_id
839: and par.routing_group_id = rgp.routing_group_id;
840: --
841: Begin

Line 1999: l_routing_group_name ghr_routing_groups.name%TYPE;

1995: l_effective_date ghr_pa_requests.effective_date%TYPE;
1996: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1997: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1998: l_full_name per_people_f.full_name%TYPE;
1999: l_routing_group_name ghr_routing_groups.name%TYPE;
2000: l_routing_group_desc ghr_routing_groups.description%TYPE;
2001: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
2002: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
2003: l_groupbox_name ghr_groupboxes.name%TYPE;

Line 2000: l_routing_group_desc ghr_routing_groups.description%TYPE;

1996: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1997: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1998: l_full_name per_people_f.full_name%TYPE;
1999: l_routing_group_name ghr_routing_groups.name%TYPE;
2000: l_routing_group_desc ghr_routing_groups.description%TYPE;
2001: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
2002: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
2003: l_groupbox_name ghr_groupboxes.name%TYPE;
2004: l_groupbox_desc ghr_groupboxes.description%TYPE;