APPS.GHR_PDI_PKG dependencies on GHR_ROUTING_LISTS

Line 6: ,p_routing_list_id OUT ghr_routing_lists.routing_list_id%TYPE

2: /* $Header: ghrwspdi.pkb 115.3 1999/11/09 22:53:15 pkm ship $ */
3:
4:
5: PROCEDURE get_last_routing_list(p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE
6: ,p_routing_list_id OUT ghr_routing_lists.routing_list_id%TYPE
7: ,p_routing_list_name OUT ghr_routing_lists.name%TYPE
8: ,p_next_seq_number OUT ghr_routing_list_members.seq_number%TYPE
9: ,p_next_user_name OUT ghr_routing_list_members.user_name%TYPE
10: ,p_next_groupbox_id OUT ghr_routing_list_members.groupbox_id%TYPE

Line 7: ,p_routing_list_name OUT ghr_routing_lists.name%TYPE

3:
4:
5: PROCEDURE get_last_routing_list(p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE
6: ,p_routing_list_id OUT ghr_routing_lists.routing_list_id%TYPE
7: ,p_routing_list_name OUT ghr_routing_lists.name%TYPE
8: ,p_next_seq_number OUT ghr_routing_list_members.seq_number%TYPE
9: ,p_next_user_name OUT ghr_routing_list_members.user_name%TYPE
10: ,p_next_groupbox_id OUT ghr_routing_list_members.groupbox_id%TYPE
11: ,p_broken IN OUT BOOLEAN) IS

Line 18: FROM ghr_routing_lists rli

14: SELECT rli.routing_list_id
15: ,rli.name
16: ,pdh.routing_seq_number
17: ,pdh.pd_routing_history_id
18: FROM ghr_routing_lists rli
19: ,ghr_pd_routing_history pdh
20: WHERE pdh.position_description_id = p_position_description_id
21: AND pdh.routing_list_id = rli.routing_list_id
22: ORDER BY pdh.pd_routing_history_id DESC;