DBA Data[Home] [Help]

APPS.AME_RULE_API dependencies on AME_ACTION_TYPE_USAGES

Line 224: from ame_action_type_usages

220: if l_allowProduction = ame_util.noProductions then
221: for i in 1..actionTypeIds.count loop
222: select count(*)
223: into l_count
224: from ame_action_type_usages
225: where rule_type = ame_util.productionRuleType
226: and action_type_id = actionTypeIds(i)
227: and p_effective_date between start_date
228: and nvl(end_date - ame_util.oneSecond, p_effective_date);

Line 500: from ame_action_type_usages atyu

496: l_item_class_id ame_item_classes.item_class_id%type;
497: --+
498: cursor getActionRuleType is
499: select atyu.rule_type
500: from ame_action_type_usages atyu
501: ,ame_actions act
502: where act.action_id = p_action_id
503: and act.action_type_id = atyu.action_type_id
504: and sysdate between act.start_date and nvl(act.end_date-(1/86400),sysdate)

Line 1829: from ame_action_type_usages aatu

1825: --+
1826: cursor getActionDetails is
1827: select aatu.action_type_id
1828: ,aatu.rule_type
1829: from ame_action_type_usages aatu
1830: ,ame_actions aa
1831: where aa.action_id = p_action_id
1832: and l_effective_date between aa.start_date
1833: and nvl(aa.end_date - ame_util.oneSecond, l_effective_date)