APPS.CS_KB_CTX_PKG dependencies on CS_KB_ELEMENTS_B

Line 234: FROM CS_KB_ELEMENTS_B eb,

230: l_content VARCHAR2(32000);
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

Line 531: FROM CS_KB_ELEMENTS_B eb,

527: l_content VARCHAR2(32000);
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

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 1500: FROM CS_KB_ELEMENTS_B eb,

1496: p_temp_clob IN OUT NOCOPY CLOB)
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

Line 1555: cs_kb_elements_b sb

1551: where se.set_id = c_setid;
1552: */
1553: SELECT se.element_id
1554: FROM CS_KB_SET_ELES se,
1555: cs_kb_elements_b sb
1556: WHERE se.set_id = c_setid
1557: AND sb.element_id = se.element_id
1558: AND sb.status = 'PUBLISHED';
1559: l_data VARCHAR2(32000);

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;

Line 1653: -- from cs_kb_elements_b

1649: -- Bug 3455203 - Perf Changes:
1650: -- Type and Number now passed as params to api
1651: -- cursor c1(c_element_id in number) is
1652: -- select element_type_id, element_number
1653: -- from cs_kb_elements_b
1654: -- where element_id = c_element_id;
1655: --rec1 c1%ROWTYPE;
1656: l_data VARCHAR2(2000);
1657: l_amt BINARY_INTEGER;