docs: @Override
  	public CommercePriceList fetchByParentCommercePriceListId(
  		long parentCommercePriceListId, boolean retrieveFromCache) {
  		Object[] finderArgs = new Object[] { parentCommercePriceListId };
  
  		Object result = null;
  
  		if (retrieveFromCache) {
  			result = finderCache.getResult(FINDER_PATH_FETCH_BY_PARENTCOMMERCEPRICELISTID,
  					finderArgs, this);
  		}
  
  		if (result instanceof CommercePriceList) {
  			CommercePriceList commercePriceList = (CommercePriceList)result;
  
  			if ((parentCommercePriceListId != commercePriceList.getParentCommercePriceListId())) {
  				result = null;
  			}
  		}
  
  		if (result == null) {
  			StringBundler query = new StringBundler(3);
  
  			query.append(_SQL_SELECT_COMMERCEPRICELIST_WHERE);
  
  			query.append(_FINDER_COLUMN_PARENTCOMMERCEPRICELISTID_PARENTCOMMERCEPRICELISTID_2);
  
  			String sql = query.toString();
  
  			Session session = null;
  
  			try {
  				session = openSession();
  
  				Query q = session.createQuery(sql);
  
  				QueryPos qPos = QueryPos.getInstance(q);
  
  				qPos.add(parentCommercePriceListId);
  
  				List<CommercePriceList> list = q.list();
  
  				if (list.isEmpty()) {
  					finderCache.putResult(FINDER_PATH_FETCH_BY_PARENTCOMMERCEPRICELISTID,
  						finderArgs, list);
  				}
  				else {
  					if (list.size() > 1) {
  						Collections.sort(list, Collections.reverseOrder());
  
  						if (_log.isWarnEnabled()) {
  							_log.warn(
  								"CommercePriceListPersistenceImpl.fetchByParentCommercePriceListId(long, boolean) with parameters (" +
  								StringUtil.merge(finderArgs) +
  								") yields a result set with more than 1 result. This violates the logical unique restriction. There is no order guarantee on which result is returned by this finder.");
  						}
  					}
  
  					CommercePriceList commercePriceList = list.get(0);
  
  					result = commercePriceList;
  
  					cacheResult(commercePriceList);
  				}
  			}
  			catch (Exception e) {
  				finderCache.removeResult(FINDER_PATH_FETCH_BY_PARENTCOMMERCEPRICELISTID,
  					finderArgs);
  
  				throw processException(e);
  			}
  			finally {
  				closeSession(session);
  			}
  		}
  
  		if (result instanceof List<?>) {
  			return null;
  		}
  		else {
  			return (CommercePriceList)result;
  		}
  	}