APPS.IRC_PCV_BUS dependencies on IRC_SEARCH_CRITERIA

Line 154: -- IRC_SEARCH_CRITERIA

150: -- {Start Of Comments}
151: --
152: -- Description:
153: -- This procedure is used to ensure that search criteria id exists in
154: -- IRC_SEARCH_CRITERIA
155: --
156: -- Pre Conditions:
157: --
158: -- In Arguments:

Line 177: select null from irc_search_criteria isc

173: l_proc varchar2(72) := g_package || 'chk_search_criteria_id';
174: l_search_criteria_id varchar2(1);
175: --
176: cursor csr_search_criteria is
177: select null from irc_search_criteria isc
178: where isc.search_criteria_id = p_search_criteria_id;
179: --
180: begin
181: hr_utility.set_location('Entering:'||l_proc,10);

Line 191: -- Check that search_criteria_id exists in irc_search_criteria.

187: );
188: --
189: hr_utility.set_location(l_proc,20);
190: if p_search_criteria_id is not null then
191: -- Check that search_criteria_id exists in irc_search_criteria.
192: hr_utility.set_location(l_proc,30);
193: open csr_search_criteria;
194: fetch csr_search_criteria into l_search_criteria_id;
195: hr_utility.set_location(l_proc,40);