public   class  PriceListDAO
    {

         private   static  PriceListDAO priceListDAO;

         public   void  init()
            {
                 if  (priceListDAO ==  null )
                    {
                        priceListDAO =  new  PriceListDAO();
                    }
            }

         public   static  PriceListDAO instance()
            {
                 return  priceListDAO;
            }

         public  PriceList findPriceListByPubIdAndStatus(Integer pubId, Integer status)
            {
                Query query = Hibernate3Support.currentSession().createQuery("select priceList from PriceList as priceList where priceList.pubId=? AND priceList.status=?");
                query.setParameter( 0 , pubId);
                query.setParameter( 1 , status);
                 return  (PriceList) query.list().get( 0 );
            }

    }