APPS.GHR_PRH_SHD dependencies on GHR_PA_ROUTING_HISTORY

Line 81: object_version_number from ghr_pa_routing_history

77: nature_of_action_id,
78: second_nature_of_action_id,
79: approval_status,
80: date_notification_sent,
81: object_version_number from ghr_pa_routing_history
82: where pa_routing_history_id = p_pa_routing_history_id;
83: --
84: l_proc varchar2(72);
85: l_fct_ret boolean;

Line 177: from ghr_pa_routing_history

173: second_nature_of_action_id,
174: approval_Status,
175: date_notification_sent,
176: object_version_number
177: from ghr_pa_routing_history
178: where pa_routing_history_id = p_pa_routing_history_id
179: for update nowait;
180: --
181: l_proc varchar2(72) := g_package||'lck';

Line 220: hr_utility.set_message_token('TABLE_NAME', 'ghr_pa_routing_history');

216: -- The object is locked therefore we need to supply a meaningful
217: -- error message.
218: --
219: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
220: hr_utility.set_message_token('TABLE_NAME', 'ghr_pa_routing_history');
221: hr_utility.raise_error;
222: End lck;
223: --
224: -- ----------------------------------------------------------------------------