my $result = $dbh->sql("SELECT * FROM $qry WHERE group_name='Procurement'");
foreach (@$result) 
{
   print @$_;
}