DBA Data[Home] [Help]

APPS.MTH_EVENT_PKG dependencies on FND_LOOKUPS

Line 120: (SELECT B.DESCRIPTION FROM FND_LOOKUPS B

116: SELECT A.PERSONNEL_FK_KEY, A.EMAIL_NOTIFICATION, A.MOBILE_NOTIFICATION,
117: A.ACTION_TYPE_CODE,
118: CASE WHEN A.ACTION_HANDLER_CODE IS NOT NULL THEN
119: DECODE( A.ACTION_HANDLER_CODE, A.ACTION_HANDLER_CODE,
120: (SELECT B.DESCRIPTION FROM FND_LOOKUPS B
121: WHERE B.LOOKUP_CODE = A.ACTION_HANDLER_CODE
122: AND B.LOOKUP_TYPE IN ('MTH_CUSTOM_PLSQL_API','MTH_CUSTOM_WS_API') ))
123: END AS ACTION_HANLDER_API, A.DOMAIN_NAME
124: FROM MTH_EVENT_ACTION_SETUP A, MTH_EVENT_SETUP C, MTH_PERSONNEL_D D