DBA Data[Home] [Help]

APPS.AME_MIGRATE_PARALLEL_CONFIG dependencies on AME_ACTIONS

Line 36: ame_actions aa,

32: and not exists
33: (select null
34: from ame_action_usages aau,
35: ame_rule_usages aru,
36: ame_actions aa,
37: ame_action_types aat
38: where aa.action_id = aau.action_id
39: and aau.rule_id = aru.rule_id
40: and aru.item_id = aagc.application_id

Line 152: from ame_actions aa,

148: where sysdate between aatc.start_date
149: and nvl(aatc.end_date - (1/86400),sysdate)
150: and not exists
151: (select /*+ use_nl (aa aru) */ null
152: from ame_actions aa,
153: ame_action_usages aau,
154: ame_rule_usages aru
155: where sysdate between aa.start_date
156: and nvl(aa.end_date - (1/86400),sysdate)