select * from MBD_STAGE.FUSE_SOFT_CANCEL_SUBS where partnername = 'vodafoneindia' and soft_cancel_active = 'Active'
