APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_SET_ELE_TYPES

Line 130: from cs_kb_set_ele_types

126: l_count pls_integer;
127: l_type_id number;
128: cursor l_types_csr is
129: select element_type_id
130: from cs_kb_set_ele_types
131: where set_type_id = p_set_type_id
132: and optional_flag = 'N';
133: begin
134: if(p_set_type_id is null or p_ele_def_tbl is null) then

Line 279: from cs_kb_set_ele_types se,

275:
276: if(p_set_id > 0) then
277: if(p_ele_id > 0) then
278: select count(*) into l_count
279: from cs_kb_set_ele_types se,
280: cs_kb_sets_b s,
281: cs_kb_elements_b e
282: where se.set_type_id = s.set_type_id
283: and se.element_type_id = e.element_type_id

Line 289: from cs_kb_set_ele_types se,

285: and e.element_id = p_ele_id;
286:
287: elsif(p_ele_type_id > 0) then
288: select count(*) into l_count
289: from cs_kb_set_ele_types se,
290: cs_kb_sets_b s
291: where se.set_type_id = s.set_type_id
292: and s.set_id = p_set_id
293: and se.element_type_id = p_ele_type_id;

Line 299: from cs_kb_set_ele_types se,

295:
296: elsif(p_set_type_id >0) then
297: if(p_ele_id >0) then
298: select count(*) into l_count
299: from cs_kb_set_ele_types se,
300: cs_kb_elements_b e
301: where se.set_type_id = p_set_type_id
302: and e.element_id = p_ele_id
303: and se.element_type_id = e.element_type_id;

Line 307: from cs_kb_set_ele_types se

303: and se.element_type_id = e.element_type_id;
304:
305: elsif(p_ele_type_id >0) then
306: select count(*) into l_count
307: from cs_kb_set_ele_types se
308: where se.set_type_id = p_set_type_id
309: and se.element_type_id = p_ele_type_id;
310: end if;
311: end if;

Line 1266: from cs_kb_set_ele_types

1262:
1263: begin
1264:
1265: select optional_flag into l_optional_flag
1266: from cs_kb_set_ele_types
1267: where set_type_id = l_set_rec.set_type_id
1268: and element_type_id = l_ele_type_id;
1269:
1270: exception