APPS.CS_KB_CTX_PKG dependencies on CS_KB_CAT_GROUP_DENORM

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

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

Line 1167: CS_KB_CAT_GROUP_DENORM b,

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