APPS.CS_KB_CTX_PKG dependencies on CS_KB_SET_CATEGORIES

Line 250: FROM cs_kb_set_categories

246: FROM CS_KB_SOLN_CATEGORIES_B
247: START WITH category_id IN
248: (
249: SELECT category_id
250: FROM cs_kb_set_categories
251: WHERE set_id = c_set_id
252: )
253: CONNECT BY PRIOR parent_category_id = category_id;
254:

Line 624: FROM cs_kb_set_categories

620: FROM CS_KB_SOLN_CATEGORIES_B
621: START WITH category_id IN
622: (
623: SELECT category_id
624: FROM cs_kb_set_categories
625: WHERE set_id = c_set_id
626: )
627: CONNECT BY PRIOR parent_category_id = category_id;
628:

Line 834: FROM cs_kb_set_categories a, CS_KB_CAT_GROUP_DENORM b

830: p_clob IN OUT NOCOPY CLOB)
831: IS
832: CURSOR c4(c_set_id IN NUMBER) IS
833: SELECT UNIQUE b.category_group_id
834: FROM cs_kb_set_categories a, CS_KB_CAT_GROUP_DENORM 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

Line 865: FROM cs_kb_set_categories a, CS_KB_CAT_GROUP_DENORM b

861:
862: FOR rec4 IN c4(p_solution_id) LOOP
863: SELECT MAX(b.visibility_position)
864: INTO l_max_cat_vis
865: FROM cs_kb_set_categories a, CS_KB_CAT_GROUP_DENORM b
866: WHERE a.category_id = b.child_category_id
867: AND b.category_group_id = rec4.category_group_id
868: AND a.set_id = p_solution_id;
869:

Line 1120: FROM cs_kb_set_categories a,

1116: -- Restrict on PUB
1117:
1118: CURSOR c4(c_element_id IN NUMBER) IS
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

Line 1166: FROM cs_kb_set_categories a,

1162: p_set_id NUMBER,
1163: p_cat_group_id NUMBER)
1164: IS
1165: SELECT NVL(MAX(b.visibility_position), -1)
1166: FROM cs_kb_set_categories a,
1167: CS_KB_CAT_GROUP_DENORM b,
1168: cs_kb_set_eles c
1169: WHERE a.category_id = b.child_category_id
1170: AND a.set_id = c.set_id