APPS.CS_KB_CTX_PKG dependencies on CS_KB_SET_CATEGORIES

Line 271: FROM cs_kb_set_categories

267: FROM CS_KB_SOLN_CATEGORIES_B
268: START WITH category_id IN
269: (
270: SELECT category_id
271: FROM cs_kb_set_categories
272: WHERE set_id = c_set_id
273: )
274: CONNECT BY PRIOR parent_category_id = category_id;
275:

Line 568: FROM cs_kb_set_categories

564: FROM CS_KB_SOLN_CATEGORIES_B
565: START WITH category_id IN
566: (
567: SELECT category_id
568: FROM cs_kb_set_categories
569: WHERE set_id = c_set_id
570: )
571: CONNECT BY PRIOR parent_category_id = category_id;
572: -- Changed the cursor to fix 11739796

Line 1217: FROM cs_kb_set_categories

1213: FROM CS_KB_SOLN_CATEGORIES_B
1214: START WITH category_id IN
1215: (
1216: SELECT category_id
1217: FROM cs_kb_set_categories
1218: WHERE set_id = c_set_id
1219: )
1220: CONNECT BY PRIOR parent_category_id = category_id;
1221:

Line 1427: FROM cs_kb_set_categories a, CS_KB_CAT_GROUP_DENORM b

1423: p_clob IN OUT NOCOPY CLOB)
1424: IS
1425: CURSOR c4(c_set_id IN NUMBER) IS
1426: SELECT UNIQUE b.category_group_id
1427: FROM cs_kb_set_categories a, CS_KB_CAT_GROUP_DENORM b
1428: WHERE a.category_id = b.child_category_id
1429: AND a.set_id = c_set_id;
1430:
1431: CURSOR c5(c_position IN NUMBER) IS

Line 1458: FROM cs_kb_set_categories a, CS_KB_CAT_GROUP_DENORM b

1454:
1455: FOR rec4 IN c4(p_solution_id) LOOP
1456: SELECT MAX(b.visibility_position)
1457: INTO l_max_cat_vis
1458: FROM cs_kb_set_categories a, CS_KB_CAT_GROUP_DENORM b
1459: WHERE a.category_id = b.child_category_id
1460: AND b.category_group_id = rec4.category_group_id
1461: AND a.set_id = p_solution_id;
1462:

Line 1713: FROM cs_kb_set_categories a,

1709: -- Restrict on PUB
1710:
1711: CURSOR c4(c_element_id IN NUMBER) IS
1712: SELECT UNIQUE b.category_group_id
1713: FROM cs_kb_set_categories a,
1714: CS_KB_CAT_GROUP_DENORM b,
1715: cs_kb_set_eles c ,
1716: cs_kb_sets_b d
1717: WHERE a.category_id = b.child_category_id

Line 1759: FROM cs_kb_set_categories a,

1755: p_set_id NUMBER,
1756: p_cat_group_id NUMBER)
1757: IS
1758: SELECT NVL(MAX(b.visibility_position), -1)
1759: FROM cs_kb_set_categories a,
1760: CS_KB_CAT_GROUP_DENORM b,
1761: cs_kb_set_eles c
1762: WHERE a.category_id = b.child_category_id
1763: AND a.set_id = c.set_id