APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_VISIBILITIES_B

Line 2126: FROM cs_kb_visibilities_b

2122: l_set_number varchar2(30);
2123:
2124: CURSOR Get_Min_Visibility IS
2125: SELECT visibility_id
2126: FROM cs_kb_visibilities_b
2127: WHERE position = ( SELECT min(position)
2128: FROM cs_kb_visibilities_b
2129: WHERE sysdate BETWEEN nvl(start_date_active, sysdate-1)
2130: AND nvl(end_date_active, sysdate+1));

Line 2128: FROM cs_kb_visibilities_b

2124: CURSOR Get_Min_Visibility IS
2125: SELECT visibility_id
2126: FROM cs_kb_visibilities_b
2127: WHERE position = ( SELECT min(position)
2128: FROM cs_kb_visibilities_b
2129: WHERE sysdate BETWEEN nvl(start_date_active, sysdate-1)
2130: AND nvl(end_date_active, sysdate+1));
2131: l_visibility_id NUMBER;
2132: l_return_status VARCHAR2(1);

Line 3317: FROM CS_KB_VISIBILITIES_B

3313: l_statement_ids_keyword VARCHAR2(30000) ;
3314:
3315: Cursor visibility_csr Is
3316: SELECT VISIBILITY_ID
3317: FROM CS_KB_VISIBILITIES_B
3318: WHERE VISIBILITY_ID =
3319: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
3320: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
3321: AND nvl(End_Date_Active, sysdate+1);

Line 3634: FROM CS_KB_VISIBILITIES_B

3630: l_statement_ids_keyword VARCHAR2(30000) ;
3631:
3632: Cursor visibility_csr Is
3633: SELECT VISIBILITY_ID
3634: FROM CS_KB_VISIBILITIES_B
3635: WHERE VISIBILITY_ID =
3636: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
3637: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
3638: AND nvl(End_Date_Active, sysdate+1);

Line 4346: FROM CS_KB_VISIBILITIES_B

4342: l_access_level_filter VARCHAR2(500);
4343:
4344: Cursor visibility_csr Is
4345: SELECT VISIBILITY_ID
4346: FROM CS_KB_VISIBILITIES_B
4347: WHERE VISIBILITY_ID =
4348: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
4349: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
4350: AND nvl(End_Date_Active, sysdate+1);