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

Line 180: p_routing_group_id ghr_routing_groups.routing_group_id%TYPE)

176:
177: END get_noa_family_name;
178:
179: FUNCTION get_routing_group_name(
180: p_routing_group_id ghr_routing_groups.routing_group_id%TYPE)
181: RETURN VARCHAR2 IS
182:
183: l_ret_val ghr_routing_groups.name%TYPE := NULL;
184:

Line 183: l_ret_val ghr_routing_groups.name%TYPE := NULL;

179: FUNCTION get_routing_group_name(
180: p_routing_group_id ghr_routing_groups.routing_group_id%TYPE)
181: RETURN VARCHAR2 IS
182:
183: l_ret_val ghr_routing_groups.name%TYPE := NULL;
184:
185: CURSOR cur_rgr IS
186: SELECT rgr.name
187: FROM ghr_routing_groups rgr

Line 187: FROM ghr_routing_groups rgr

183: l_ret_val ghr_routing_groups.name%TYPE := NULL;
184:
185: CURSOR cur_rgr IS
186: SELECT rgr.name
187: FROM ghr_routing_groups rgr
188: WHERE rgr.routing_group_id = p_routing_group_id;
189:
190: BEGIN
191: FOR cur_rgr_rec IN cur_rgr LOOP