APPS.GME_GMEPRACT_XMLP_PKG SQL Statements

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

Line: 59

    CURSOR CUR_SELECT IS
      SELECT
        MEANING
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_CODE = SORT_BY
        AND LOOKUP_TYPE = 'GME_GMEPRACT_SORT';

Line: 67

    OPEN CUR_SELECT;

Line: 68

    FETCH CUR_SELECT
     INTO X_SORT1;

Line: 70

    CLOSE CUR_SELECT;

Line: 100

      SELECT
        ORGANIZATION_CODE
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = P_ORG_ID;