APPS.AME_RUL_BUS dependencies on AME_ITEM_CLASSES

Line 94: -- ame_item_classes.item_class_id. Also check that ITEM_CLASS_ID is not

90: -- {Start Of Comments}
91: --
92: -- Description:
93: -- Validates that the item_class_id is a foreign key to
94: -- ame_item_classes.item_class_id. Also check that ITEM_CLASS_ID is not
95: -- inserted for list modification and substitutions rules.
96: --
97: -- Prerequisites:
98: -- None.

Line 130: from ame_item_classes

126: l_proc varchar2(72) := g_package||'chk_item_class_id';
127: tempCount integer;
128: cursor c_sel1 is
129: select null
130: from ame_item_classes
131: where
132: item_class_id = p_item_class_id and
133: p_effective_date between start_date and
134: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 302: from ame_item_classes

298: ,p_rule_type in number) is
299:
300: cursor getItemClassName(p_item_class_id in number) is
301: select name
302: from ame_item_classes
303: where sysdate between start_date and nvl(end_date-(1/84600),sysdate)
304: and item_class_id = p_item_class_id;
305: l_item_class_name ame_item_classes.name%type;
306:

Line 305: l_item_class_name ame_item_classes.name%type;

301: select name
302: from ame_item_classes
303: where sysdate between start_date and nvl(end_date-(1/84600),sysdate)
304: and item_class_id = p_item_class_id;
305: l_item_class_name ame_item_classes.name%type;
306:
307: begin
308:
309: if (p_rule_type = ame_util.listModRuleType or