How to run a LIKE query with values from another table

select
a.nm_dokumen_singkat,
b.kata,
b.program
from
revenue_non_smile_2015 a,
kamus_revenue b
where
upper(a.nm_dokumen_singkat) like '%'||upper(b.kata)||'%'