DBA Data[Home] [Help]

APPS.WSH_WSHRDBDR_XMLP_PKG dependencies on WSH_LOOKUPS

Line 236: WSH_LOOKUPS

232: SELECT
233: MEANING
234: INTO ITEM_DISPLAY_MEANING
235: FROM
236: WSH_LOOKUPS
237: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
238: AND LOOKUP_CODE = P_ITEM_DISPLAY;
239: RP_FLEX_OR_DESC := ITEM_DISPLAY_MEANING;
240: EXCEPTION

Line 307: WSH_LOOKUPS

303: SELECT
304: MEANING
305: INTO SCODE
306: FROM
307: WSH_LOOKUPS
308: WHERE LOOKUP_CODE = P_SOURCE_SYSTEM
309: AND LOOKUP_TYPE = 'SOURCE_SYSTEM';
310: EXCEPTION
311: WHEN NO_DATA_FOUND THEN

Line 629: WSH_LOOKUPS

625: SELECT
626: MEANING
627: INTO SCODE
628: FROM
629: WSH_LOOKUPS
630: WHERE LOOKUP_CODE = CF_SOURCE_CODEFORMULA.SOURCE_CODE
631: AND LOOKUP_TYPE = 'SOURCE_SYSTEM';
632: RETURN (SCODE);
633: END CF_SOURCE_CODEFORMULA;