APPS.CS_KB_CTX_PKG dependencies on CS_KB_ELEMENTS_TL

Line 235: CS_KB_ELEMENTS_TL et,

231:
232: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
233: SELECT et.name, et.description, eb.element_id, eb.element_number
234: FROM CS_KB_ELEMENTS_B eb,
235: CS_KB_ELEMENTS_TL et,
236: CS_KB_SET_ELES se
237: WHERE se.set_id = c_setid
238: AND eb.element_id = se.element_id
239: AND eb.element_id = et.element_id

Line 532: CS_KB_ELEMENTS_TL et,

528:
529: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
530: SELECT et.name, et.description, eb.element_id, eb.element_number
531: FROM CS_KB_ELEMENTS_B eb,
532: CS_KB_ELEMENTS_TL et,
533: CS_KB_SET_ELES se
534: WHERE se.set_id = c_setid
535: AND eb.element_id = se.element_id
536: AND eb.element_id = et.element_id

Line 811: FROM CS_KB_ELEMENTS_TL tl, CS_KB_ELEMENTS_B b

807: CURSOR GET_STMT_CONTENT IS
808: SELECT tl.element_id, tl.LANGUAGE, b.status,
809: b.element_number, tl.name, tl.description,
810: b.access_level, b.element_type_id
811: FROM CS_KB_ELEMENTS_TL tl, CS_KB_ELEMENTS_B b
812: WHERE tl.ROWID = p_rowid
813: AND tl.element_id = b.element_id;
814: BEGIN
815: -- Fetch statement id, language, and status based on rowid

Line 1501: CS_KB_ELEMENTS_TL et,

1497: IS
1498: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
1499: SELECT et.name, et.description, eb.element_id, eb.element_number
1500: FROM CS_KB_ELEMENTS_B eb,
1501: CS_KB_ELEMENTS_TL et,
1502: CS_KB_SET_ELES se
1503: WHERE se.set_id = c_setid
1504: AND eb.element_id = se.element_id
1505: AND eb.element_id = et.element_id

Line 1604: -- from cs_kb_elements_tl tl, cs_kb_elements_b b

1600: -- Bug 3455203 - Perf Changes:
1601: -- Name and Desc now passed as params to api
1602: -- cursor c1(c_element_id in number, c_lang in varchar2) is
1603: -- select b.element_number, tl.name, tl.description
1604: -- from cs_kb_elements_tl tl, cs_kb_elements_b b
1605: -- where tl.element_id = c_element_id
1606: -- and tl.language = c_lang
1607: -- and tl.element_id = b.element_id;
1608: -- rec1 c1%ROWTYPE;