APPS.AME_ATR_BUS dependencies on AME_ITEM_CLASSES

Line 157: -- ame_item_classes.item_class_id.

153: -- {Start Of Comments}
154: --
155: -- Description:
156: -- Validates that the item_class_id is a foreign key to
157: -- ame_item_classes.item_class_id.
158: --
159: -- Prerequisites:
160: -- None.
161: --

Line 191: from ame_item_classes

187: l_proc varchar2(72) := g_package||'chk_item_class_id';
188: tempCount integer;
189: cursor c_sel1 is
190: select null
191: from ame_item_classes
192: where
193: item_class_id = p_item_class_id and
194: p_effective_date between start_date and
195: nvl(end_date - ame_util.oneSecond, p_effective_date) ;