delete from tbl_CRM_Affiliations where ownerId = and ownerType = and partnerId = and partnerType = insert into tbl_CRM_Affiliations( ownerId, ownerType, partnerId, partnerType, orgId, orgType, affiliationStatus, affiliationType, affiliationDate, partnerAffiliateNbr, sourceId, sourceType ) values , ( , , , , , , 'A', , , , , 'USR' ) update tbl_OPR_CLientOperators set lastUpdated = , lastUpdatedBy = where ownerId = and fsltablecode = and operatorId =