APPS.CS_KB_SEARCH_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

    select nvl(cs_kb_set_used_sums.used_count, 0)
    from cs_kb_set_used_sums, cs_kb_used_sum_defs_b
    where cs_kb_set_used_sums.def_id = cs_kb_used_sum_defs_b.def_id
    and cs_kb_used_sum_defs_b.default_flag = 'Y'
    and cs_kb_set_used_sums.set_id = p_set_id;