APPS.CS_KB_CTX_PKG dependencies on CS_KB_ELEMENTS_B

Line 213: FROM CS_KB_ELEMENTS_B eb,

209: l_content VARCHAR2(32000);
210:
211: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
212: SELECT et.name, et.description, eb.element_id, eb.element_number
213: FROM CS_KB_ELEMENTS_B eb,
214: CS_KB_ELEMENTS_TL et,
215: CS_KB_SET_ELES se
216: WHERE se.set_id = c_setid
217: AND eb.element_id = se.element_id

Line 423: FROM CS_KB_ELEMENTS_TL tl, CS_KB_ELEMENTS_B b

419: CURSOR GET_STMT_CONTENT IS
420: SELECT tl.element_id, tl.LANGUAGE, b.status,
421: b.element_number, tl.name, tl.description,
422: b.access_level, b.element_type_id
423: FROM CS_KB_ELEMENTS_TL tl, CS_KB_ELEMENTS_B b
424: WHERE tl.ROWID = p_rowid
425: AND tl.element_id = b.element_id;
426: BEGIN
427: -- Fetch statement id, language, and status based on rowid

Line 907: FROM CS_KB_ELEMENTS_B eb,

903: p_temp_clob IN OUT NOCOPY CLOB)
904: IS
905: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
906: SELECT et.name, et.description, eb.element_id, eb.element_number
907: FROM CS_KB_ELEMENTS_B eb,
908: CS_KB_ELEMENTS_TL et,
909: CS_KB_SET_ELES se
910: WHERE se.set_id = c_setid
911: AND eb.element_id = se.element_id

Line 962: cs_kb_elements_b sb

958: where se.set_id = c_setid;
959: */
960: SELECT se.element_id
961: FROM CS_KB_SET_ELES se,
962: cs_kb_elements_b sb
963: WHERE se.set_id = c_setid
964: AND sb.element_id = se.element_id
965: AND sb.status = 'PUBLISHED';
966: l_data VARCHAR2(32000);

Line 1011: -- from cs_kb_elements_tl tl, cs_kb_elements_b b

1007: -- Bug 3455203 - Perf Changes:
1008: -- Name and Desc now passed as params to api
1009: -- cursor c1(c_element_id in number, c_lang in varchar2) is
1010: -- select b.element_number, tl.name, tl.description
1011: -- from cs_kb_elements_tl tl, cs_kb_elements_b b
1012: -- where tl.element_id = c_element_id
1013: -- and tl.language = c_lang
1014: -- and tl.element_id = b.element_id;
1015: -- rec1 c1%ROWTYPE;

Line 1060: -- from cs_kb_elements_b

1056: -- Bug 3455203 - Perf Changes:
1057: -- Type and Number now passed as params to api
1058: -- cursor c1(c_element_id in number) is
1059: -- select element_type_id, element_number
1060: -- from cs_kb_elements_b
1061: -- where element_id = c_element_id;
1062: --rec1 c1%ROWTYPE;
1063: l_data VARCHAR2(2000);
1064: l_amt BINARY_INTEGER;