APPS.AME_ATU_BUS dependencies on AME_ITEM_CLASS_USAGES

Line 142: from ame_item_class_usages

138: l_exists varchar2(1);
139: l_proc varchar2(72) := g_package||'chk_attribute_item_class';
140: cursor c_sel1 is
141: select null
142: from ame_item_class_usages
143: where application_id = p_application_id and item_class_id =
144: ( select item_class_id from ame_attributes
145: where attribute_id = p_attribute_id and sysdate between start_date
146: and nvl(end_date - ame_util.oneSecond,sysdate))