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


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