APPS.CS_KB_CTX_PKG dependencies on CS_KB_VISIBILITIES_B

Line 1432: SELECT visibility_id FROM cs_kb_visibilities_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
1432: SELECT visibility_id FROM cs_kb_visibilities_b
1433: -- (secure) klou
1434: WHERE position <= c_position
1435: ORDER BY visibility_id;
1436:

Line 1465: FROM cs_kb_sets_b a, cs_kb_visibilities_b b

1461: AND a.set_id = p_solution_id;
1462:
1463: SELECT b.position
1464: INTO l_soln_vis
1465: FROM cs_kb_sets_b a, cs_kb_visibilities_b b
1466: WHERE a.visibility_id = b.visibility_id
1467: AND a.set_id = p_solution_id;
1468:
1469: IF l_soln_vis < l_max_cat_vis THEN

Line 1724: SELECT visibility_id FROM cs_kb_visibilities_b

1720: AND c.set_id = d.set_id
1721: AND c.element_id = c_element_id;
1722:
1723: CURSOR c5(c_position IN NUMBER) IS
1724: SELECT visibility_id FROM cs_kb_visibilities_b
1725: -- (secure) klou
1726: WHERE position <= c_position
1727: ORDER BY visibility_id;
1728:

Line 1735: cs_kb_visibilities_b v

1731: CURSOR c6(c_element_id IN NUMBER) IS
1732: SELECT s.set_id, v.position
1733: FROM cs_kb_set_eles se,
1734: cs_kb_Sets_B s,
1735: cs_kb_visibilities_b v
1736: WHERE se.element_id = c_element_id
1737: AND se.set_id = s.set_id
1738: AND s.status = 'PUB'
1739: AND s.visibility_id = v.visibility_id;

Line 1817: -- from cs_kb_sets_b a, cs_kb_visibilities_b b

1813: -- Bug 3455203 - Perf Changes:
1814: -- Posn now retrieved via c6 cursor
1815: -- select b.position
1816: -- into l_soln_vis
1817: -- from cs_kb_sets_b a, cs_kb_visibilities_b b
1818: -- where a.visibility_id = b.visibility_id
1819: -- and a.set_id = rec6.set_id;
1820:
1821: -- perf11510