"select EMPCODE from EMPTABLE where ISDELETED='0' and PARTCODE = ?PARTCODE ",
IDAO.class
);
roleUser.set("PARTCODE", getGroupId());
roleUser.select();
} else if ( getReferenceRole() != null && getReferenceRole().getMapping(instance) != null ) {
roleUser = GenericDAO.createDAOImpl(
DefaultConnectionFactory.create(),
"select E.EMPCODE from EMPTABLE E, (select PARTCODE, EMPCODE from EMPTABLE where EMPCODE= ?empCode) T where E.ISDELETED='0' and E.PARTCODE = T.PARTCODE",
IDAO.class