DELETE FROM m_warranty_type_for_sell_price_so Z
    WHERE EXISTS (
        SELECT TRUE
            FROM ul_warranty_type_for_sell_price_so A
            INNER JOIN ul_header B
                ON B.ul_header_id=A.ul_header_id
            INNER JOIN t_ou D
                ON A.ou_code = D.ou_code AND B.tenant_id = D.tenant_id
            INNER JOIN m_product E
                ON A.product_code = E.product_code AND B.tenant_id = E.tenant_id
            INNER JOIN t_combo_value F
                ON F.combo_id = vPriceLevelComboId AND F.prop_key = A.price_level
            INNER JOIN m_sell_price_product_for_so G
                ON B.tenant_id=G.tenant_id
                AND D.ou_id=G.ou_id
                AND E.product_id=G.product_id
                AND A.sell_price_date > G.date_from
                AND A.sell_price_date < G.date_to
                AND F.code = G.price_level
            INNER JOIN m_warranty_type H
                ON A.warranty_type_code=H.warranty_type_code AND H.tenant_id=B.tenant_id
            WHERE A.ul_header_id=pUlHeaderId AND
                A.status=vStatusOk AND
                Z.tenant_id = B.tenant_id AND
                Z.sell_price_product_for_so_id = G.sell_price_product_for_so_id AND
                Z.warranty_type_id = H.warranty_type_id
        );