/* (non-Javadoc) * @see com.mg.merp.reference.CatalogPriceServiceLocal#findActual(java.util.Date, com.mg.merp.reference.model.Catalog, com.mg.merp.reference.model.Currency) */ @PermitAll public CatalogPrice findActual(Date actualityDate, Catalog catalog, Currency currency) { DetachedCriteria dc = DetachedCriteria.forClass(CatalogPrice.class, "cp") .setProjection(Projections.max("cp.InAction")) .add(Restrictions.eq("cp.Catalog", catalog)) .add(Restrictions.eq("cp.Currency", currency)) .add(Restrictions.le("cp.InAction", actualityDate)); return OrmTemplate.getInstance() .findUniqueByCriteria( OrmTemplate.createCriteria(CatalogPrice.class) .add(Restrictions.eq("Catalog", catalog)) .add(Subqueries.propertyEq("InAction", dc))); }