APPS.CS_KB_CTX_PKG dependencies on CS_KB_ELEMENTS_TL

Line 214: CS_KB_ELEMENTS_TL et,

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
218: AND eb.element_id = et.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 908: CS_KB_ELEMENTS_TL et,

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
912: AND eb.element_id = et.element_id

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;