APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_VISIBILITIES_B

Line 2130: FROM cs_kb_visibilities_b

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

Line 2132: FROM cs_kb_visibilities_b

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

Line 3342: FROM CS_KB_VISIBILITIES_B

3338: l_statement_ids_keyword VARCHAR2(30000) ;
3339:
3340: Cursor visibility_csr Is
3341: SELECT VISIBILITY_ID
3342: FROM CS_KB_VISIBILITIES_B
3343: WHERE VISIBILITY_ID =
3344: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
3345: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
3346: AND nvl(End_Date_Active, sysdate+1);

Line 3659: FROM CS_KB_VISIBILITIES_B

3655: l_statement_ids_keyword VARCHAR2(30000) ;
3656:
3657: Cursor visibility_csr Is
3658: SELECT VISIBILITY_ID
3659: FROM CS_KB_VISIBILITIES_B
3660: WHERE VISIBILITY_ID =
3661: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
3662: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
3663: AND nvl(End_Date_Active, sysdate+1);

Line 4371: FROM CS_KB_VISIBILITIES_B

4367: l_access_level_filter VARCHAR2(500);
4368:
4369: Cursor visibility_csr Is
4370: SELECT VISIBILITY_ID
4371: FROM CS_KB_VISIBILITIES_B
4372: WHERE VISIBILITY_ID =
4373: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
4374: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
4375: AND nvl(End_Date_Active, sysdate+1);