my $result = $dbh->selectall_arrayref(
   "SELECT DISTINCT(application) FROM table_name WHERE
   group_name='Procurement'"
);
foreach (@$result) {
   print @$_;
}