DBA Data[Home] [Help]

APPS.WSH_WSHRDBDR_XMLP_PKG dependencies on WSH_LOOKUPS

Line 214: WSH_LOOKUPS

210: SELECT
211: MEANING
212: INTO ITEM_DISPLAY_MEANING
213: FROM
214: WSH_LOOKUPS
215: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
216: AND LOOKUP_CODE = P_ITEM_DISPLAY;
217: RP_FLEX_OR_DESC := ITEM_DISPLAY_MEANING;
218: EXCEPTION

Line 285: WSH_LOOKUPS

281: SELECT
282: MEANING
283: INTO SCODE
284: FROM
285: WSH_LOOKUPS
286: WHERE LOOKUP_CODE = P_SOURCE_SYSTEM
287: AND LOOKUP_TYPE = 'SOURCE_SYSTEM';
288: EXCEPTION
289: WHEN NO_DATA_FOUND THEN

Line 607: WSH_LOOKUPS

603: SELECT
604: MEANING
605: INTO SCODE
606: FROM
607: WSH_LOOKUPS
608: WHERE LOOKUP_CODE = CF_SOURCE_CODEFORMULA.SOURCE_CODE
609: AND LOOKUP_TYPE = 'SOURCE_SYSTEM';
610: RETURN (SCODE);
611: END CF_SOURCE_CODEFORMULA;