APPS.CS_KB_CTX_PKG dependencies on CS_KB_CAT_GROUP_DENORM

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 1714: CS_KB_CAT_GROUP_DENORM b,

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
1718: AND a.set_id = c.set_id

Line 1760: CS_KB_CAT_GROUP_DENORM b,

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
1764: AND a.set_id = p_set_id --rec6.set_id