SELECT A.*
           ,FN_SY_CLASS_R01(star,'CLASS_NM') AS star_nm
           , B.class_l_seq
           , B.class_m_seq
FROM HT_MST A
INNER JOIN HT_MAPPING B ON A.ht_mst_seq = B.ht_mst_seq
WHERE B.channel_comp_seq = :channel_comp_seq
AND A.htl_name like concat('%',:search_txt,'%')
GROUP BY A.ht_mst_seq