DBA Data[Home] [Help]

APPS.AME_ACTION_USAGES_API2 dependencies on AME_RULE_USAGES

Line 98: AME_RULE_USAGES ARU

94: X_RULE_ID in integer
95: ) is
96: select ACA.APPLICATION_ID
97: from AME_CALLING_APPS ACA,
98: AME_RULE_USAGES ARU
99: where ACA.APPLICATION_ID = ARU.ITEM_ID
100: and ARU.RULE_ID = X_RULE_ID
101: and sysdate between ARU.START_DATE
102: and nvl(ARU.END_DATE - (1/86400), sysdate);