public GraphicAssessmentVo getActiveGraphicAssessment(GraphicAssessmentRefVo voRef) {
    List<?> list =
        getDomainFactory()
            .find(
                "from GraphicAssessment as g1_1 where g1_1.id = :grID",
                new String[] {"grID"},
                new Object[] {voRef.getID_GraphicAssessment()});

    if (list == null || list.size() == 0) return null;

    return GraphicAssessmentVoAssembler.create((GraphicAssessment) list.get(0));
  }
  public GraphicAssessmentVo getActiveGraphicAssessment(UserDefinedAssessmentType type) {
    List<?> list =
        getDomainFactory()
            .find(
                "from GraphicAssessment as g1_1 where g1_1.assessmentType.id = :TYPE and g1_1.activeStatus.id = :STATUS",
                new String[] {"TYPE", "STATUS"},
                new Object[] {
                  new Integer(type.getID()),
                  new Integer(PreActiveActiveInactiveStatus.ACTIVE.getID())
                });

    if (list == null || list.size() == 0) return null;

    return GraphicAssessmentVoAssembler.create((GraphicAssessment) list.get(0));
  }