DBA Data[Home] [Help]

APPS.CS_KB_SECURITY_PVT dependencies on CS_KB_CATEGORY_GROUPS_VL

Line 852: FROM CS_KB_CATEGORY_GROUPS_VL

848: ) RETURN VARCHAR2 IS
849:
850: CURSOR Check_Name_Exists IS
851: SELECT count(*)
852: FROM CS_KB_CATEGORY_GROUPS_VL
853: WHERE name = P_NAME
854: AND category_group_id <> P_CATEGORY_GROUP_ID;
855:
856: l_count NUMBER :=0;

Line 1139: FROM CS_KB_CATEGORY_GROUPS_VL

1135: l_login NUMBER := FND_GLOBAL.login_id;
1136:
1137: CURSOR Check_Update IS
1138: SELECT COUNT(*)
1139: FROM CS_KB_CATEGORY_GROUPS_VL
1140: WHERE CATEGORY_GROUP_ID = P_CATEGORY_GROUP_ID
1141: AND NAME = P_NAME;
1142:
1143: BEGIN

Line 1300: FROM CS_KB_CATEGORY_GROUPS_VL

1296:
1297:
1298: CURSOR CHECK_DELETE IS
1299: SELECT count(*)
1300: FROM CS_KB_CATEGORY_GROUPS_VL
1301: WHERE category_group_id = P_CATEGORY_GROUP_ID;
1302:
1303: CURSOR CHECK_MEMBERS IS
1304: SELECT count(*)