DBA Data[Home] [Help]

APPS.AME_ACTION_USAGES_API dependencies on AME_RULE_USAGES

Line 227: AME_RULE_USAGES ARU

223: X_RULE_ID in integer
224: ) is
225: select ACA.APPLICATION_ID
226: from AME_CALLING_APPS ACA,
227: AME_RULE_USAGES ARU
228: where ACA.APPLICATION_ID = ARU.ITEM_ID
229: and ARU.RULE_ID = X_RULE_ID
230: and sysdate between ARU.START_DATE
231: and nvl(ARU.END_DATE - (1/86400), sysdate);