Assuming you have mapped StoreDetail with references to both Store and FiscalPeriod, which would be the natural mapping, you could just query for : select sd from StoreDetail sd where sd.store.id = :storeId and sd.fiscalPeriod.id = :fiscalPeriodId.

Either way this RFE has gotten zero votes, so going to reject