DBA Data[Home] [Help]

APPS.AME_RULE_USAGES_API dependencies on FND_APPLICATION_VL

Line 29: FND_APPLICATION_VL FA

25: X_TRANSACTION_TYPE_ID in VARCHAR2
26: ) is
27: select ACA.APPLICATION_ID
28: from AME_CALLING_APPS ACA,
29: FND_APPLICATION_VL FA
30: where FA.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
31: and nvl(ACA.TRANSACTION_TYPE_ID,'NULL') = nvl(X_TRANSACTION_TYPE_ID,'NULL')
32: and FA.APPLICATION_ID = ACA.FND_APPLICATION_ID
33: and ((ACA.START_DATE - (1/86400)) <= sysdate)