DBA Data[Home] [Help]

APPS.AME_RULE_UTILITY_PKG dependencies on AME_ITEM_CLASS_USAGES

Line 207: from ame_item_class_usages itu

203: and rul.rule_id = ruleIdIn
204: and sysdate between itc.start_date and nvl(itc.end_date - (1/86400), sysdate)
205: and rul.end_date = endDateIn
206: and itc.item_class_id not in (select item_class_id
207: from ame_item_class_usages itu
208: where itu.application_id = applicationIdIn
209: and sysdate between itu.start_date
210: and nvl(itu.end_date - (1/86400), sysdate));
211: --+

Line 558: from ame_item_class_usages itu

554: or
555: (sysdate < rul.start_date and rul.start_date < nvl(rul.end_date, rul.start_date + (1/86400)))
556: )
557: and itc.item_class_id not in (select item_class_id
558: from ame_item_class_usages itu
559: where itu.application_id = applicationIdIn
560: and sysdate between itu.start_date
561: and nvl(itu.end_date - (1/86400), sysdate));
562: --+