APPS.CS_KB_CTX_PKG dependencies on CS_KB_SET_ELES

Line 215: CS_KB_SET_ELES se

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
219: AND eb.status = 'PUBLISHED' --- added 03/16/2004

Line 909: CS_KB_SET_ELES se

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
913: AND eb.status = 'PUBLISHED' --- added 03/16/2004

Line 957: from CS_KB_SET_ELES se

953: IS
954: CURSOR c1(c_setid IN NUMBER) IS
955: /* (perf11510): functional fix
956: select se.element_id
957: from CS_KB_SET_ELES se
958: where se.set_id = c_setid;
959: */
960: SELECT se.element_id
961: FROM CS_KB_SET_ELES se,

Line 961: FROM CS_KB_SET_ELES se,

957: from CS_KB_SET_ELES se
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';

Line 1122: cs_kb_set_eles c ,

1118: CURSOR c4(c_element_id IN NUMBER) IS
1119: SELECT UNIQUE b.category_group_id
1120: FROM cs_kb_set_categories a,
1121: CS_KB_CAT_GROUP_DENORM b,
1122: cs_kb_set_eles c ,
1123: cs_kb_sets_b d
1124: WHERE a.category_id = b.child_category_id
1125: AND a.set_id = c.set_id
1126: AND d.status = 'PUB'

Line 1140: FROM cs_kb_set_eles se,

1136: -- Bug 3455203 - Perf Changes:
1137: -- Restrict on PUB
1138: CURSOR c6(c_element_id IN NUMBER) IS
1139: SELECT s.set_id, v.position
1140: FROM cs_kb_set_eles se,
1141: cs_kb_Sets_B s,
1142: cs_kb_visibilities_b v
1143: WHERE se.element_id = c_element_id
1144: AND se.set_id = s.set_id

Line 1168: cs_kb_set_eles c

1164: IS
1165: SELECT NVL(MAX(b.visibility_position), -1)
1166: FROM cs_kb_set_categories a,
1167: CS_KB_CAT_GROUP_DENORM b,
1168: cs_kb_set_eles c
1169: WHERE a.category_id = b.child_category_id
1170: AND a.set_id = c.set_id
1171: AND a.set_id = p_set_id --rec6.set_id
1172: AND b.category_group_id = p_cat_group_id --rec4.category_group_id

Line 1333: FROM cs_kb_set_eles a

1329: p_clob IN OUT NOCOPY CLOB)
1330: IS
1331: CURSOR get_all_stmts(p_element_id IN NUMBER) IS
1332: SELECT a.element_id
1333: FROM cs_kb_set_eles a
1334: WHERE a.element_id <> p_element_id --:b1
1335: AND a.set_id IN (
1336: SELECT s.set_id
1337: FROM cs_kb_set_eles se,

Line 1337: FROM cs_kb_set_eles se,

1333: FROM cs_kb_set_eles a
1334: WHERE a.element_id <> p_element_id --:b1
1335: AND a.set_id IN (
1336: SELECT s.set_id
1337: FROM cs_kb_set_eles se,
1338: cs_kb_sets_b s
1339: WHERE se.element_id = p_element_id
1340: AND se.set_id = s.set_id
1341: AND s.status = 'PUB');

Line 1343: -- from cs_kb_set_eles a, cs_kb_set_eles b, cs_kb_sets_b c

1339: WHERE se.element_id = p_element_id
1340: AND se.set_id = s.set_id
1341: AND s.status = 'PUB');
1342: -- select a.element_id
1343: -- from cs_kb_set_eles a, cs_kb_set_eles b, cs_kb_sets_b c
1344: -- where b.set_id = a.set_id
1345: -- and a.set_id = c.set_id
1346: -- and c.status = 'PUB'
1347: -- and b.element_id = p_element_id