// set the beginning of the query
    	SQL.append("select input_data.STT_ABBRVTN, ");
    	SQL.append("       input_data.WC_CLASS_CODE, ");
    	SQL.append("       DECODE(ncci_data.NCCI_CLASS_CODE, null, input_data.WC_CLASS_CODE, ");
    	SQL.append("                                               ncci_data.NCCI_CLASS_CODE) NCCI_CLASS_CODE ");
    	SQL.append("from ");
    	SQL.append("( ");

    	// loop through all Data items and build the logical table
    	List inputParamsList = aDTO.getNodes("Data");
    	for (int i=0; i<inputParamsList.size(); i++)
		{
			DTO aParamDto = (DTO)inputParamsList.get(i);
			String state = aParamDto.getValue(STATE_TAG).getAsString();
			String wcCode = aParamDto.getValue(CLASS_CD_TAG).getAsString();
			String paddedWCCode = wcCode;
			
			// if the state is DE or PA and the class code is not 4 digits, we need to prepend zeros
			// since the ref table in database has 4 digit class codes
			if ((("DE").equalsIgnoreCase(state) || ("PA").equalsIgnoreCase(state)) && wcCode.length() < 4)
			{
				if (wcCode.length() == 1)
					paddedWCCode = "000" + wcCode;
				else if (wcCode.length() == 2)
					paddedWCCode = "00" + wcCode;
				else if (wcCode.length() == 3)
					paddedWCCode = "0" + wcCode;
			}
			
			SQL.append("select '" 
+ state 
+ "' STT_ABBRVTN, '" 
+ paddedWCCode 
+  "' PADDED_CLASS_CODE, '" 
+ wcCode 
+ "' WC_CLASS_CODE from dual ");
			if (i < inputParamsList.size()-1)
				SQL.append("UNION ");
		}
		
    	// append the final part of the query
    	SQL.append(") input_data, ");
    	SQL.append("WC_NCCI_CODE_XREF ncci_data ");
		SQL.append("where input_data.STT_ABBRVTN = ncci_data.STT_ABBRVTN (+) ");
		SQL.append("and input_data.PADDED_CLASS_CODE = ncci_data.WC_CLASS_CODE (+) ");

		//System.out.println("##### QUERY:\n" + SQL.toString() + "\n\n");
		aSearchCriteriaDTO = aDTO;