APPS.CS_KB_SECURITY_PVT dependencies on DUAL

Line 200: SELECT CS_KB_VISIBILITIES_B_S.nextval INTO l_seq from dual;

196:
197: -- If Visibility is null (Not called from OA) then generate from
198: -- the sequence.
199: IF P_VISIBILITY_ID IS NULL THEN
200: SELECT CS_KB_VISIBILITIES_B_S.nextval INTO l_seq from dual;
201: ELSE
202: l_seq := P_VISIBILITY_ID;
203: END IF;
204: --dbms_output.put_line('Sequence is ='||l_seq);

Line 960: SELECT CS_KB_CATEGORY_GROUPS_B_S.nextval INTO l_seq from dual;

956: RAISE INVALID_IN_PARAMETERS;
957: ELSE
958:
959: IF P_CATEGORY_GROUP_ID IS NULL THEN
960: SELECT CS_KB_CATEGORY_GROUPS_B_S.nextval INTO l_seq from dual;
961: ELSE
962: l_seq := P_CATEGORY_GROUP_ID;
963: END IF;
964:

Line 2958: FROM dual;

2954: TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('CS_KB_ASSIGNED_STATEMENT_VISIBILITY_LEVEL',
2955: v_user,
2956: v_resp,
2957: v_app ))
2958: FROM dual;
2959:
2960: CURSOR IS_COMPLETE_SOLN_VIEWABLE (v_cat_grp NUMBER,
2961: v_soln_vis NUMBER) IS
2962: --v_stmt_vis NUMBER) IS