APPS.CS_KB_CTX_PKG dependencies on CS_KB_SETS_B

Line 123: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b

119: b.status,
120: tl.content_cache,
121: b.set_number,
122: b.set_type_id
123: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b
124: WHERE tl.ROWID = p_rowid
125: AND b.set_id = tl.set_id;
126:
127: l_set_number VARCHAR2(30);

Line 136: from CS_KB_SETS_TL tl, CS_KB_SETS_B b

132: /*
133: -- Get the solution id and language, based on the rowid
134: select tl.set_id, tl.language, b.status, tl.content_cache
135: into l_solnid, l_lang, l_status, l_clob
136: from CS_KB_SETS_TL tl, CS_KB_SETS_B b
137: where tl.rowid = p_rowid
138: and b.set_id = tl.set_id;
139: */
140: OPEN set_content_csr(p_rowid);

Line 545: FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl

541: p_temp_clob IN OUT NOCOPY CLOB)
542: IS
543: CURSOR c2(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
544: SELECT b.set_number, tl.name
545: FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl
546: WHERE b.set_id = c_set_id
547: AND tl.set_id = b.set_id
548: AND tl.LANGUAGE = c_lang;
549:

Line 582: FROM CS_KB_SETS_B

578: p_clob IN OUT NOCOPY CLOB)
579: IS
580: CURSOR c2(c_set_id IN NUMBER) IS
581: SELECT set_type_id, set_number
582: FROM CS_KB_SETS_B
583: WHERE set_id = c_set_id;
584:
585: l_soln_number VARCHAR2(30);
586: l_type_id NUMBER;

Line 872: FROM cs_kb_sets_b a, cs_kb_visibilities_b b

868: AND a.set_id = p_solution_id;
869:
870: SELECT b.position
871: INTO l_soln_vis
872: FROM cs_kb_sets_b a, cs_kb_visibilities_b b
873: WHERE a.visibility_id = b.visibility_id
874: AND a.set_id = p_solution_id;
875:
876: IF l_soln_vis < l_max_cat_vis THEN

Line 1123: cs_kb_sets_b d

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'
1127: AND c.set_id = d.set_id

Line 1141: cs_kb_Sets_B s,

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
1145: AND s.status = 'PUB'

Line 1224: -- from cs_kb_sets_b a, cs_kb_visibilities_b b

1220: -- Bug 3455203 - Perf Changes:
1221: -- Posn now retrieved via c6 cursor
1222: -- select b.position
1223: -- into l_soln_vis
1224: -- from cs_kb_sets_b a, cs_kb_visibilities_b b
1225: -- where a.visibility_id = b.visibility_id
1226: -- and a.set_id = rec6.set_id;
1227:
1228: -- perf11510

Line 1338: cs_kb_sets_b s

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');
1342: -- select a.element_id

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