APPS.GHR_PDH_SHD dependencies on GHR_PD_ROUTING_HISTORY

Line 75: item_key from ghr_pd_routing_history

71: routing_list_id,
72: routing_seq_number,
73: date_notification_sent,
74: object_version_number,
75: item_key from ghr_pd_routing_history
76: where pd_routing_history_id = p_pd_routing_history_id;
77: --
78: l_proc varchar2(72) := g_package||'api_updating';
79: l_fct_ret boolean;

Line 166: from ghr_pd_routing_history

162: routing_seq_number,
163: date_notification_sent,
164: object_version_number,
165: item_key
166: from ghr_pd_routing_history
167: where pd_routing_history_id = p_pd_routing_history_id
168: for update nowait;
169: --
170: l_proc varchar2(72) := g_package||'lck';

Line 209: hr_utility.set_message_token('TABLE_NAME', 'ghr_pd_routing_history');

205: -- The object is locked therefore we need to supply a meaningful
206: -- error message.
207: --
208: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
209: hr_utility.set_message_token('TABLE_NAME', 'ghr_pd_routing_history');
210: hr_utility.raise_error;
211: End lck;
212: --
213: -- ----------------------------------------------------------------------------