SELECT eai_batchId FROM tbl_EML_Campaign WHERE CampaignID = AND OwnerID = AND FSL_TableCode = delete from tbl_EML_Campaign where ownerId = and fsl_tablecode = and campaignId = and lastUpdatedDate = and statusCd = 'PEN' DELETE from tbl_EML_CampaignGroupLnk WHERE CampaignID = ; DELETE from tbl_EML_CampaignRecipients WHERE CampaignID = ; DELETE from tbl_EML_CampaignRecipients WHERE CampaignID = ; DELETE from tbl_EML_CampaignHyperlinks WHERE CampaignID = ; DELETE from tbl_EAI_InboundBatches WHERE batchId = and OwnerID = and ownerType = DELETE FROM tbl_ORG_AttributeLinks WHERE (mstr_attrTypeID = AND mstr_attrID = ) OR (child_attrTypeID = AND child_attrID = )