APPS.GHR_PDI_PKG dependencies on GHR_PD_ROUTING_HISTORY

Line 19: ,ghr_pd_routing_history pdh

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;
23:

Line 33: FROM ghr_pd_routing_history pdh

29:
30:
31: CURSOR cur_pdh_last IS
32: SELECT pdh.pd_routing_history_id
33: FROM ghr_pd_routing_history pdh
34: WHERE pdh.position_description_id = p_position_description_id
35: ORDER BY pdh.pd_routing_history_id DESC;
36: -- Again the order by saves us having to do a max
37: CURSOR cur_rlm (p_routing_list_id IN NUMBER

Line 91: l_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;

87: ,p_personnelist_flag in out varchar2
88: ,p_approver_flag in out varchar2
89: ,p_reviewer_flag in out varchar2) IS
90:
91: l_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
92: l_user_name ghr_pd_routing_history.user_name%TYPE;
93:
94: CURSOR cur_gp_user IS
95: select pdh.groupbox_id

Line 92: l_user_name ghr_pd_routing_history.user_name%TYPE;

88: ,p_approver_flag in out varchar2
89: ,p_reviewer_flag in out varchar2) IS
90:
91: l_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
92: l_user_name ghr_pd_routing_history.user_name%TYPE;
93:
94: CURSOR cur_gp_user IS
95: select pdh.groupbox_id
96: ,pdh.user_name

Line 97: from ghr_pd_routing_history pdh

93:
94: CURSOR cur_gp_user IS
95: select pdh.groupbox_id
96: ,pdh.user_name
97: from ghr_pd_routing_history pdh
98: where pdh.position_description_id = p_position_description_id
99: order by pdh.pd_routing_history_id desc;
100:
101: CURSOR cur_first_user IS

Line 103: from ghr_pd_routing_history pdh

99: order by pdh.pd_routing_history_id desc;
100:
101: CURSOR cur_first_user IS
102: select pdh.groupbox_id
103: from ghr_pd_routing_history pdh
104: where pdh.position_description_id = p_position_description_id
105: and pdh.user_name = l_user_name
106: and pdh.groupbox_id is not NULL
107: and not exists (select 1

Line 108: from ghr_pd_routing_history pdh2

104: where pdh.position_description_id = p_position_description_id
105: and pdh.user_name = l_user_name
106: and pdh.groupbox_id is not NULL
107: and not exists (select 1
108: from ghr_pd_routing_history pdh2
109: where pdh2.position_description_id = p_position_description_id
110: and pdh2.user_name <> l_user_name
111: and pdh2.pd_routing_history_id > pdh.pd_routing_history_id)
112: order by pdh.pd_routing_history_id asc;