AND #TransType = 'P');