APPS.CS_KB_SOLN_CATEGORIES_PVT dependencies on CS_KB_SETS_B

Line 140: from cs_kb_set_categories sl, cs_kb_sets_b b

136: */
137: begin
138:
139: select /*+ index(sl) */ count( * ) into n_child_solutions
140: from cs_kb_set_categories sl, cs_kb_sets_b b
141: where sl.category_id = p_category_id
142: and b.set_id = sl.set_id
143: --and b.status = 'PUB';
144: and (b.status = 'PUB' or (b.status <> 'OBS' and b.latest_version_flag = 'Y'));

Line 754: from cs_kb_set_categories sl, cs_kb_sets_b b

750:
751: cursor get_pub_inprog(cp_category_id number)
752: is
753: select /*+ index(sl) */ b.set_id
754: from cs_kb_set_categories sl, cs_kb_sets_b b
755: where sl.category_id = cp_category_id
756: and b.set_id = sl.set_id
757: and (b.status = 'PUB' or (b.status <> 'OBS' and b.latest_version_flag = 'Y'));
758: