DBA Data[Home] [Help]

APPS.AME_RULES_API dependencies on AME_ACTIONS

Line 42: select ACTION_ID from AME_ACTIONS

38: (
39: X_ACTION_TYPE_ID in NUMBER,
40: X_PARAMETER in VARCHAR2
41: ) is
42: select ACTION_ID from AME_ACTIONS
43: where ACTION_TYPE_ID = X_ACTION_TYPE_ID
44: and nvl(PARAMETER,'NULL') = nvl(X_PARAMETER,'NULL')
45: and sysdate between START_DATE
46: and nvl(END_DATE - (1/86400), sysdate);