APPS.CS_KB_SECURITY_PVT dependencies on CS_KB_SETS_B

Line 648: FROM CS_KB_SETS_B

644: ) IS
645:
646: CURSOR USED_IN_SOLUTION IS
647: SELECT count(*)
648: FROM CS_KB_SETS_B
649: WHERE visibility_id = P_VISIBILITY_ID
650: AND STATUS <> 'OBS'
651: AND LATEST_VERSION_FLAG = 'Y';
652:

Line 2964: FROM CS_KB_SETS_B S,

2960: CURSOR IS_COMPLETE_SOLN_VIEWABLE (v_cat_grp NUMBER,
2961: v_soln_vis NUMBER) IS
2962: --v_stmt_vis NUMBER) IS
2963: SELECT count(*)
2964: FROM CS_KB_SETS_B S,
2965: CS_KB_VISIBILITIES_B V
2966: WHERE S.Set_Id = P_SET_ID
2967: AND S.Visibility_id = V.Visibility_id
2968: AND V.Position >= (SELECT Vis.Position