APPS.WSH_WSHRDVLS_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

    SELECT
      NAME
    INTO COMPANY_NAME
    FROM
      GL_LEDGERS_PUBLIC_V
    WHERE LEDGER_ID = P_SOB_ID;

Line: 56

      SELECT
        WND.NAME
      FROM
        WSH_NEW_DELIVERIES WND,
        WSH_DELIVERY_LEGS WDL
      WHERE WND.DELIVERY_ID = WDL.DELIVERY_ID
        AND WDL.DELIVERY_LEG_ID = P_PARENT_DELIVERY_LEG_ID;