DBA Data[Home] [Help]

APPS.AME_RULES_API2 dependencies on AME_ITEM_CLASSES

Line 29: from AME_ITEM_CLASSES

25: (
26: X_ITEM_CLASS_NAME in VARCHAR2
27: ) is
28: select ITEM_CLASS_ID
29: from AME_ITEM_CLASSES
30: where NAME = X_ITEM_CLASS_NAME
31: and sysdate between START_DATE
32: and nvl(END_DATE - (1/86400), sysdate);
33: cursor CSR_GET_RULE_ID

Line 142: from AME_ITEM_CLASSES

138: (
139: X_ITEM_CLASS_NAME in VARCHAR2
140: ) is
141: select ITEM_CLASS_ID
142: from AME_ITEM_CLASSES
143: where NAME = X_ITEM_CLASS_NAME
144: and sysdate between START_DATE
145: and nvl(END_DATE - (1/86400), sysdate);
146: cursor CSR_GET_RULE_COUNT