APPS.CE_CEBSLERR_XMLP_PKG SQL Statements

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

Line: 9

 select SUBSTR(argument1,INSTR(argument1,'=',1)+1,LENGTH(argument1)),
SUBSTR(argument2,INSTR(argument2,'=',1)+1,LENGTH(argument2))
into P_MAP_ID_1,P_FILE_NAME_1
        from FND_CONCURRENT_REQUESTS
where request_id=P_CONC_REQUEST_ID;

Line: 16

      SELECT
        count(*)
      INTO CP_FATAL_ERR_COUNT
      FROM
        CE_SQLLDR_ERRORS
      WHERE REC_NO IS NULL
      OR STATEMENT_NUMBER IS NULL
      OR BANK_ACCOUNT_NUM IS NULL;

Line: 24

      SELECT
        count(*)
      INTO CP_TOTAL_ERR_COUNT
      FROM
        CE_SQLLDR_ERRORS;

Line: 32

          SELECT
            FORMAT_NAME,
            DESCRIPTION,
            FORMAT_TYPE,
            RTRIM(CONTROL_FILE_NAME
                 ,'.ctl') || '.ctl'
          INTO C_NAME,C_DESCRIPTION,C_FORMAT_TYPE,C_CONTROL_FILE_NAME
          FROM
            CE_BANK_STMT_INT_MAP
          WHERE MAP_ID = P_MAP_ID_1;