SELECT A.* 
FROM RA_DISP A
INNER JOIN RA_MST B ON A.ra_mst_seq = B.ra_mst_seq
WHERE B.channel_comp_seq = :channel_comp_seq
AND A.disp_yn = 'Y'
AND B.homepage_url like concat(:homepage_url,'%')