APPS.XDP_ADAPTER_CORE_DB dependencies on XDP_FES

Line 56: from XDP_ADAPTER_REG a, XDP_FES f

52:
53: cursor G_Get_All_Adapters is
54: select a.CHANNEL_NAME, a.PROCESS_ID, a.ADAPTER_STATUS, a.FE_ID,
55: a.ADAPTER_TYPE, f.ROLE_NAME, a.ADAPTER_DISPLAY_NAME
56: from XDP_ADAPTER_REG a, XDP_FES f
57: where a.fe_id = f.fe_id;
58:
59: -- Gets all automatic (AUTO and SOD) adapters for a Controller instance that are/may
60: -- be required to be started. AUTO adapters are started whereas SOD adapters are checked if

Line 67: from XDP_ADAPTER_REG xar, XDP_ADAPTER_TYPES_B xat, XDP_FES xfe

63:
64: cursor G_Get_Automatic_Adapters (SvcInstID number) is
65: select CHANNEL_NAME, STARTUP_MODE, XAR.FE_ID, XFE.FULFILLMENT_ELEMENT_NAME,
66: decode(ADAPTER_CLASS, 'NONE', 'N', 'Y') IS_IMPLEMENTED, APPLICATION_MODE
67: from XDP_ADAPTER_REG xar, XDP_ADAPTER_TYPES_B xat, XDP_FES xfe
68: where ADAPTER_STATUS in (XDP_ADAPTER.pv_statusStopped,
69: XDP_ADAPTER.pv_statusStoppedError,
70: XDP_ADAPTER.pv_statusTerminated)
71: and STARTUP_MODE in (XDP_ADAPTER.pv_startAutomatic, XDP_ADAPTER.pv_startOnDemand)