APPS.XDP_ADAPTER_CORE_DB dependencies on XDP_FE_SW_GEN_LOOKUP

Line 1204: from XDP_FE_SW_GEN_LOOKUP XSW, XDP_FE_GENERIC_CONFIG XGC

1200: p_GenCountActive OUT NOCOPY NUMBER, p_GenCountFuture OUT NOCOPY NUMBER)
1201: is
1202: cursor c_get_valid_generics (c_fe_id NUMBER, c_AdapterType VARCHAR2) is
1203: select XGC.START_DATE
1204: from XDP_FE_SW_GEN_LOOKUP XSW, XDP_FE_GENERIC_CONFIG XGC
1205: where XGC.FE_ID = c_fe_id and
1206: XSW.ADAPTER_TYPE = c_AdapterType and
1207: XSW.FE_SW_GEN_LOOKUP_ID = XGC.FE_SW_GEN_LOOKUP_ID and
1208: ((XGC.END_DATE is null) or ((XGC.END_DATE is not null) and (XGC.END_DATE > SYSDATE)));