DBA Data[Home] [Help]

APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SETS_VL

Line 835: FROM CS_KB_SETS_VL

831: l_status := 'SAV';
832: END IF;
833: --check unique set name IN audit table
834: SELECT COUNT(*) INTO l_count
835: FROM CS_KB_SETS_VL
836: WHERE name = p_name
837: AND status = 'PUB';
838:
839: IF(l_count >0) THEN

Line 1099: FROM CS_KB_SETS_VL

1095: ELSE
1096:
1097: --check unique set name IN audit table (except those with same set_number)
1098: SELECT COUNT(*) INTO l_count
1099: FROM CS_KB_SETS_VL
1100: WHERE name = p_name
1101: AND status = 'PUB'
1102: AND set_number <> p_set_number;
1103: