APPS.CS_KB_SET_ELE_TYPES_PKG dependencies on CS_KB_SETS_B

Line 185: -- Select e.Set_Id from cs_kb_set_eles e, cs_kb_sets_b s, cs_kb_elements_b t

181: if (P_SET_TYPE_ID is null or P_ELEMENT_TYPE_ID is null) then return ERROR_STATUS; end if;
182:
183: -- select count(*) into l_count
184: -- from cs_kb_set_eles where Set_Id In (
185: -- Select e.Set_Id from cs_kb_set_eles e, cs_kb_sets_b s, cs_kb_elements_b t
186: -- where t.element_type_id = p_element_type_id and s.set_type_id = p_set_type_id and
187: -- e.Set_Id = s.Set_Id and e.Element_Id = t.Element_Id);
188: select /*+ INDEX(s) */ count(*) into l_count
189: from cs_kb_sets_b s

Line 189: from cs_kb_sets_b s

185: -- Select e.Set_Id from cs_kb_set_eles e, cs_kb_sets_b s, cs_kb_elements_b t
186: -- where t.element_type_id = p_element_type_id and s.set_type_id = p_set_type_id and
187: -- e.Set_Id = s.Set_Id and e.Element_Id = t.Element_Id);
188: select /*+ INDEX(s) */ count(*) into l_count
189: from cs_kb_sets_b s
190: where s.set_type_id = p_set_type_id
191: and s.status <> 'OBS'
192: and (s.latest_version_flag = 'Y' OR s.viewable_version_flag = 'Y')
193: and exists (select 'x'