APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_SET_ELE_TYPES

Line 132: from cs_kb_set_ele_types

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

Line 281: from cs_kb_set_ele_types se,

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

Line 291: from cs_kb_set_ele_types se,

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

Line 301: from cs_kb_set_ele_types se,

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

Line 309: from cs_kb_set_ele_types se

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

Line 1268: from cs_kb_set_ele_types

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