IF EXISTS ( SELECT * 
            FROM   sys.views 
            WHERE  name='pal_vReceiptListing' and type='v')
BEGIN
    DROP VIEW [dbo].[pal_vReceiptListing]
END



IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[sp_RemittanceListingByDate]') 
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[sp_RemittanceListingByDate]
