190: -- {Start Of Comments}
191: --
192: -- Description:
193: -- This procedure is used to ensure that offer Id exists 194: -- in table irc_offers. 195: --
196: -- Pre Conditions:
197: -- offer Id should exist in the table.
198: --
Line 220: from IRC_OFFERS
216: l_offer_id irc_offer_status_history.offer_id%TYPE;
217: --
218: cursor csr_offer is
219: select 1 220: from IRC_OFFERS 221: where offer_id = p_offer_id;
222: --
223: begin
224: --