APPS.GME_GMEBCHTK_XMLP_PKG SQL Statements

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

Line: 87

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

Line: 95

    OPEN CUR_SELECT;

Line: 96

    FETCH CUR_SELECT
     INTO X_SORT1;

Line: 98

    CLOSE CUR_SELECT;

Line: 112

      SELECT
        ORGANIZATION_CODE
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 130

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE VIEW_APPLICATION_ID = 553
        AND LOOKUP_TYPE = 'GME_SUBINVENTORY_TYPE'
        AND LOOKUP_CODE = L_TYPE;

Line: 152

  update gme_batch_header set print_count = print_count + 1 where organization_id = p_org_id and
						batch_no = batch_no1;