APPS.CS_KB_SEARCH_PVT dependencies on CS_KB_SET_USED_SUMS

Line 8: select nvl(cs_kb_set_used_sums.used_count, 0)

4: FUNCTION Get_Set_Usage_Count( p_set_id IN NUMBER ) RETURN NUMBER
5: IS
6: l_total NUMBER := 0;
7: Cursor Gt_usage_count_csr(p_set_id in NUMBER) IS
8: select nvl(cs_kb_set_used_sums.used_count, 0)
9: from cs_kb_set_used_sums, cs_kb_used_sum_defs_b
10: where cs_kb_set_used_sums.def_id = cs_kb_used_sum_defs_b.def_id
11: and cs_kb_used_sum_defs_b.default_flag = 'Y'
12: and cs_kb_set_used_sums.set_id = p_set_id;

Line 9: from cs_kb_set_used_sums, cs_kb_used_sum_defs_b

5: IS
6: l_total NUMBER := 0;
7: Cursor Gt_usage_count_csr(p_set_id in NUMBER) IS
8: select nvl(cs_kb_set_used_sums.used_count, 0)
9: from cs_kb_set_used_sums, cs_kb_used_sum_defs_b
10: where cs_kb_set_used_sums.def_id = cs_kb_used_sum_defs_b.def_id
11: and cs_kb_used_sum_defs_b.default_flag = 'Y'
12: and cs_kb_set_used_sums.set_id = p_set_id;
13: BEGIN

Line 10: where cs_kb_set_used_sums.def_id = cs_kb_used_sum_defs_b.def_id

6: l_total NUMBER := 0;
7: Cursor Gt_usage_count_csr(p_set_id in NUMBER) IS
8: select nvl(cs_kb_set_used_sums.used_count, 0)
9: from cs_kb_set_used_sums, cs_kb_used_sum_defs_b
10: where cs_kb_set_used_sums.def_id = cs_kb_used_sum_defs_b.def_id
11: and cs_kb_used_sum_defs_b.default_flag = 'Y'
12: and cs_kb_set_used_sums.set_id = p_set_id;
13: BEGIN
14:

Line 12: and cs_kb_set_used_sums.set_id = p_set_id;

8: select nvl(cs_kb_set_used_sums.used_count, 0)
9: from cs_kb_set_used_sums, cs_kb_used_sum_defs_b
10: where cs_kb_set_used_sums.def_id = cs_kb_used_sum_defs_b.def_id
11: and cs_kb_used_sum_defs_b.default_flag = 'Y'
12: and cs_kb_set_used_sums.set_id = p_set_id;
13: BEGIN
14:
15: If p_set_id Is Not Null Then
16: Open Gt_usage_count_csr(p_set_id);