@SuppressWarnings("rawtypes") public LocSvcProviderSysLiteVo getProviderServiceForOrderInv(OrderInvestigationRefVo orderInv) { if(orderInv == null || orderInv.getID_OrderInvestigation() == null) throw new CodingRuntimeException("orderInv parameter is null in method getProviderServiceForOrderInv"); DomainFactory factory = getDomainFactory(); String hql = "select inv.providerService from OrderInvestigation as orderInv left join orderInv.investigation as inv left join inv.providerService as provSer where orderInv.id = :idOrderInv"; List providers = factory.find(hql,new String[] {"idOrderInv"},new Object[] {orderInv.getID_OrderInvestigation()}); if(providers != null && providers.size() == 1) return LocSvcProviderSysLiteVoAssembler.create((LocSvcProviderSys) providers.get(0)); return null; }