APPS.IRC_PCV_SHD dependencies on IRC_PROF_AREA_CRITERIA_VALUES

Line 53: from irc_prof_area_criteria_values

49: prof_area_criteria_value_id
50: ,search_criteria_id
51: ,professional_area
52: ,object_version_number
53: from irc_prof_area_criteria_values
54: where prof_area_criteria_value_id = p_prof_area_criteria_value_id;
55: --
56: l_fct_ret boolean;
57: --

Line 122: from irc_prof_area_criteria_values

118: prof_area_criteria_value_id
119: ,search_criteria_id
120: ,professional_area
121: ,object_version_number
122: from irc_prof_area_criteria_values
123: where prof_area_criteria_value_id = p_prof_area_criteria_value_id
124: for update nowait;
125: --
126: l_proc varchar2(72) := g_package||'lck';

Line 171: fnd_message.set_token('TABLE_NAME', 'irc_prof_area_criteria_values');

167: -- The object is locked therefore we need to supply a meaningful
168: -- error message.
169: --
170: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
171: fnd_message.set_token('TABLE_NAME', 'irc_prof_area_criteria_values');
172: fnd_message.raise_error;
173: End lck;
174: --
175: -- ----------------------------------------------------------------------------