APPS.WSH_WSHRDVLD_XMLP_PKG SQL Statements

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

Line: 22

    SELECT
      NAME
    INTO COMPANY_NAME
    FROM
      GL_LEDGERS_PUBLIC_V
    WHERE LEDGER_ID = P_SOB_ID;

Line: 65

      SELECT
        CUSTOMER_JOB
      FROM
        OE_ORDER_LINES_ALL
      WHERE LINE_ID = P_LINE_ID;

Line: 84

      SELECT
        CUSTOMER_JOB
      FROM
        OE_ORDER_LINES_ALL
      WHERE LINE_ID = P_LINE_ID;