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);