DBA Data[Home] [Help]

APPS.CS_KB_SECURITY_PVT dependencies on CS_KB_VISIBILITIES_VL

Line 42: FROM CS_KB_VISIBILITIES_VL

38: ) RETURN VARCHAR2 IS
39:
40: CURSOR Check_Name_Exists IS
41: SELECT count(*)
42: FROM CS_KB_VISIBILITIES_VL
43: WHERE name = P_NAME
44: AND sysdate BETWEEN nvl(Start_Date_Active, SYSDATE-1)
45: AND nvl(End_Date_Active, SYSDATE+1)
46: AND visibility_id <> P_VISIBILITY_ID;

Line 474: FROM CS_KB_VISIBILITIES_VL

470: CURSOR Check_Update (v_vis_id NUMBER,
471: v_name VARCHAR2,
472: v_desc VARCHAR2 ) IS
473: SELECT COUNT(*)
474: FROM CS_KB_VISIBILITIES_VL
475: WHERE visibility_id = v_vis_id
476: AND name = v_name;
477:
478: BEGIN