APPS.AME_RULE_UTILITY_PKG dependencies on AME_ACTION_TYPE_USAGES

Line 32: ,ame_action_type_usages axu

28: --+
29: begin
30: select axu.rule_type into dummy
31: from ame_actions act
32: ,ame_action_type_usages axu
33: where act.action_id = actionIdIn
34: and act.action_type_id = axu.action_type_id
35: and sysdate between act.start_date and nvl(act.end_date - (1/86400), sysdate)
36: and sysdate between axu.start_date and nvl(axu.end_date - (1/86400), sysdate);

Line 77: ,ame_action_type_usages axu

73: from ame_action_types aty
74: ,ame_actions act
75: ,ame_action_usages acu
76: ,ame_rules rul
77: ,ame_action_type_usages axu
78: where rul.rule_id = ruleIdIn
79: and rul.rule_id = acu.rule_id
80: and acu.action_id = act.action_id
81: and act.action_type_id = aty.action_type_id

Line 103: ,ame_action_type_usages axu

99: from ame_action_types aty
100: ,ame_actions act
101: ,ame_action_usages acu
102: ,ame_rules rul
103: ,ame_action_type_usages axu
104: where rul.rule_id = ruleIdIn
105: and rul.rule_id = acu.rule_id
106: and acu.action_id = act.action_id
107: and act.action_type_id = aty.action_type_id

Line 2050: ,ame_action_type_usages atyu

2046: ,p_action_id in integer) is
2047: select count(*)
2048: from ame_rules rul
2049: ,ame_action_usages acu
2050: ,ame_action_type_usages atyu
2051: ,ame_actions act
2052: where act.action_id <> p_action_id
2053: and rul.rule_id = p_rule_id
2054: and rul.rule_id = acu.rule_id