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_LISTS

Line 387: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE

383:
384: END get_default_routing_group;
385:
386: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
387: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
388: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
389: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
390: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
391: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE

Line 388: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE

384: END get_default_routing_group;
385:
386: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
387: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
388: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
389: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
390: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
391: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE
392: ,p_broken IN OUT NOCOPY BOOLEAN) IS

Line 404: FROM ghr_routing_lists rli

400: SELECT rli.routing_list_id
401: ,rli.name
402: ,prh.routing_seq_number
403: ,prh.pa_routing_history_id
404: FROM ghr_routing_lists rli
405: ,ghr_pa_routing_history prh
406: WHERE prh.pa_request_id = p_pa_request_id
407: AND prh.routing_list_id = rli.routing_list_id
408: ORDER BY prh.pa_routing_history_id DESC;