APPS.CS_KB_CTX_PKG dependencies on CS_KB_VISIBILITIES_B

Line 839: SELECT visibility_id FROM cs_kb_visibilities_b

835: WHERE a.category_id = b.child_category_id
836: AND a.set_id = c_set_id;
837:
838: CURSOR c5(c_position IN NUMBER) IS
839: SELECT visibility_id FROM cs_kb_visibilities_b
840: -- (secure) klou
841: WHERE position <= c_position
842: ORDER BY visibility_id;
843:

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 1131: SELECT visibility_id FROM cs_kb_visibilities_b

1127: AND c.set_id = d.set_id
1128: AND c.element_id = c_element_id;
1129:
1130: CURSOR c5(c_position IN NUMBER) IS
1131: SELECT visibility_id FROM cs_kb_visibilities_b
1132: -- (secure) klou
1133: WHERE position <= c_position
1134: ORDER BY visibility_id;
1135:

Line 1142: cs_kb_visibilities_b v

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'
1146: AND s.visibility_id = v.visibility_id;

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