APPS.ONT_OEXOEWFR_XMLP_PKG SQL Statements

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

Line: 43

      SELECT
        1
      FROM
        OE_ORDER_HOLDS_ALL OH
      WHERE OH.HEADER_ID = HEADER_ID1
        AND OH.LINE_ID IS NULL
        AND OH.HOLD_RELEASE_ID IS NULL
        AND ROWNUM = 1;

Line: 52

      SELECT
        1
      FROM
        OE_ORDER_HOLDS_ALL OH
      WHERE OH.LINE_ID = CF_HOLD_VALUEFORMULA.LINE_ID
        AND OH.HOLD_RELEASE_ID IS NULL
        AND ROWNUM = 1;

Line: 200

      SELECT
        SOB.NAME
      INTO L_SOB_NAME
      FROM
        GL_SETS_OF_BOOKS SOB
      WHERE SOB.SET_OF_BOOKS_ID = P_SOB_ID;

Line: 265

    SELECT
      REPLACE(P_CONCAT_VALUE
             ,'.-1'
             ,'')
    INTO P_CONCAT_VALUE
    FROM
      DUAL;

Line: 286

      SELECT
        WIAS.END_DATE
      FROM
        WF_ITEM_ACTIVITY_STATUSES WIAS,
        WF_PROCESS_ACTIVITIES WPA
      WHERE WIAS.ITEM_TYPE = 'OEOL'
        AND WIAS.ITEM_KEY = TO_CHAR(LINE_ID)
        AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
        AND WPA.ACTIVITY_NAME = 'INVOICE_INTERFACE';

Line: 296

      SELECT
        WIAS.END_DATE
      FROM
        WF_ITEM_ACTIVITY_STATUSES WIAS,
        WF_PROCESS_ACTIVITIES WPA
      WHERE WIAS.ITEM_TYPE = 'OEOH'
        AND WIAS.ITEM_KEY = TO_CHAR(HEADER_ID1)
        AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
        AND WPA.ACTIVITY_NAME = 'HEADER_INVOICE_INTERFACE';

Line: 343

    SELECT
      NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
         ,0)
    INTO V_MASTER_ORG
    FROM
      DUAL;