APPS.GME_GMEBCHPL_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      ABS(TRANS_QTY)
    INTO TEMP
    FROM
      DUAL;

Line: 17

    SELECT
      ABS(SUM_TRANS_QTY)
    INTO TEMP
    FROM
      DUAL;

Line: 28

    SELECT
      ABS(SUM_TRANS_QTY2)
    INTO TEMP
    FROM
      DUAL;

Line: 94

    SELECT
      ABS(TRANS_QTY2)
    INTO TEMP
    FROM
      DUAL;

Line: 128

    CURSOR CUR_SELECT IS
      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_CODE = SORTBY
        AND LOOKUP_TYPE = 'PM_RIPMIUSR_SORT';

Line: 136

    OPEN CUR_SELECT;

Line: 137

    FETCH CUR_SELECT
     INTO X_SORT1;

Line: 139

    CLOSE CUR_SELECT;

Line: 193

      SELECT
        ORGANIZATION_CODE
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = P_ORG_ID;