@Override
    public List<LoyaltyProgramFactorsModel> getLoyaltyProgramFactorsByCurrencyType(String currencyType) {
        final String queryString = "SELECT * " +
                "FROM {" + LoyaltyProgramDetailsModel._TYPECODE + "} " +
                "JOIN {" + CurrencyType._TYPECODE + "}" +
                "ON {" + CurrencyType._TYPECODE + "} = {" + LoyaltyProgramDetailsModel.CURRENCYTYPE + "} WHERE {" + CurrencyType._TYPECODE + "}?=currencyType ";

        final FlexibleSearchQuery query = new FlexibleSearchQuery(queryString);
        query.addQueryParameter("currencyType", currencyType);
        return flexibleSearchService.<LoyaltyProgramFactorsModel>search(query).getResult();
    }

SELECT *
  FROM {
    LoyaltyProgramDetails AS d
  JOIN CurrencyType AS c
ON {c.pk} = {d.currencyType} }
WHERE {c.code} = 'EUR'