DBA Data[Home] [Help]

APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SETS_VL

Line 821: FROM CS_KB_SETS_VL

817: l_status := 'SAV';
818: END IF;
819: --check unique set name IN audit table
820: SELECT COUNT(*) INTO l_count
821: FROM CS_KB_SETS_VL
822: WHERE name = p_name
823: AND status = 'PUB';
824:
825: IF(l_count >0) THEN

Line 1085: FROM CS_KB_SETS_VL

1081: ELSE
1082:
1083: --check unique set name IN audit table (except those with same set_number)
1084: SELECT COUNT(*) INTO l_count
1085: FROM CS_KB_SETS_VL
1086: WHERE name = p_name
1087: AND status = 'PUB'
1088: AND set_number <> p_set_number;
1089: