DBA Data[Home] [Help]

APPS.AME_RULE_USAGES_API2 dependencies on AME_CALLING_APPS

Line 29: from AME_CALLING_APPS ACA,

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

Line 101: from AME_CALLING_APPS ACA,

97: X_APPLICATION_SHORT_NAME in VARCHAR2,
98: X_TRANSACTION_TYPE_ID in VARCHAR2
99: ) is
100: select ACA.APPLICATION_ID
101: from AME_CALLING_APPS ACA,
102: FND_APPLICATION_VL FA
103: where FA.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
104: and nvl(ACA.TRANSACTION_TYPE_ID,'NULL') = nvl(X_TRANSACTION_TYPE_ID,'NULL')
105: and FA.APPLICATION_ID = ACA.FND_APPLICATION_ID